View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
dhstein dhstein is offline
external usenet poster
 
Posts: 266
Default Macro stops with "Large Amount of Data" Message

Thanks for the information - it worked great

"FSt1" wrote:

hi
add this to the begining of your code...
Application.DisplayAlerts = false

this will turn off all of excel's built in error messages.

but...".big word"....be sure to turn them back on at the end of your code...
very unwise not to..........
Application.DisplayAlerts = TRUE

regards
FSt1



"dhstein" wrote:

I have macro that copies some data from a workbook and then tries to close
it. I want it to run without stopping, but I get the message that there is a
large amount of data in the clipboard - and I need to click "OK". Is there a
way to suppress that message so the macro will complete? Thanks.