View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default clipboard pop up

After the copy and paste and before you close the other workbook

Application.CutCopyMode = False

Assuming you want to dump the data in the clipboard. And
--
Regards,
Tom Ogilvy

"Michelle" wrote in message
...
I have a program that goes and copies a bunch of data from
another workbook then closes the other workbook. I get
the following pop up every time it does this and would
like to know is there anything I can do to stop this.

There is a large amout of information on the clipboard.
********
You have to then click yes not or cancel