ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Not showing "info on clipboard" message (https://www.excelbanter.com/excel-programming/272616-not-showing-info-clipboard-message.html)

P Cheek

Not showing "info on clipboard" message
 
How do I turn off the automatically generated Excel message "There is
a large amount of information on the clipboard. Do you want to be able
to paste this information into another program later? To save it on
the clipboard so that you can past it later, click yes. To delete it
from the clipboard and free memory, click No.

I am copying specific information from one worksheet to another, then
closing the first worksheet. This is all done by a macro. However,
once you close the first sheet, the above message appears.

Using the Application.DisplayAlerts.False then True did not work.


All times are GMT +1. The time now is 05:22 PM.

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