ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   clipboard pop up (https://www.excelbanter.com/excel-programming/312565-clipboard-pop-up.html)

Michelle

clipboard pop up
 
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

Tom Ogilvy

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





All times are GMT +1. The time now is 10:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com