View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
try
application.displayalerts=false
'close the file
application.displayalerts=true

"jamessinc" wrote:

I have a macro that will open a file and copy a range to another file. Then
I will close the file I copied the range from but I am asked if I wish to
clear the clipboard after each copy. How do I stop the clipboard request
from stoping the macro?

Thanks
Jim