Thread: macros
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default macros

Hi,

Application.displayalerts=false

your code

Application.displayalerts=true

Mike

"Sanford Lefkowitz" wrote:

I am running a macrom that includes a number of copies and pastes of large
amounts of data. I keep getting the message about there being a large amount
of data on the clipboard. Do I want to keep it. After clicking No the, macro
proceeds.
How do I either prevent this message from popping up? or automatically
answer it 'No'

TIA
Sanford