MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do I say "Yes" to "Empty Clipboard?" in VBA?


Posted by Melanie Swarner on October 22, 2001 5:07 AM

I have a macro that copies a sheet and pastes it into another file. It then closes the sheet. However, it asks if I want to empty the clipboard or save the contents for future use. How do I "answer" the question in my macro so my user doesn't have to?

Thanks!


Posted by Juan Pablo on October 22, 2001 5:15 AM

Put

Application.CutCopyMode = False

before you close the file. That will erase the clipboard.

Juan Pablo

Posted by Melanie Swarner on October 22, 2001 5:45 AM

Thanks! (nt)