clear clipboard

[Super Slueth]

Hello

I using code to open an excel sheet and copy all the contents of that
sheet to another excell sheet.

I then go back and close the first sheet.

I get a prompt for the user that the clipboard contains a lot f data
and do you want to save this yes or no.

How can I in code clear the clipboard and stop this user prompt

Many thanks

 

[Chip Pearson]

Try

Application.CutCopyMode = False


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)