View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Disable Clipboard Memory Saver

Hi Chad,

Add the following line to your code ( after the paste line):

Application.CutCopyMode = False

---
Regards,
Norman



"CLS" wrote in message
...
Hi All,

I have code that copies a range to another workbook. I then close it
'myfile.close false' but it brings up an alert that asks to save the
clipboard info. set displayalerts to false, but now it takes for ever to
continue after that point. Is there a setting or command to disable this
clipboard feature? I NEVER want to remember what is on the clipboard.

Thanks
Chad