Not showing "info on clipboard" message

P

P Cheek

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top