Hi
I'm importing (copying and pasting) a large amount of data from one workbook to another using VBA. When I close the workbook I copied from I get a message that there is a large amount of data on the clipboard click yes to keep it or no to delete it.
How do I turn that message off or clear the clipboard before closing so my VBA code doesn't get interrupted?
To kill messages :- Application.DisplayAlerts = false
Don't forget to reset to TRUE at the end of your code
Elegant Simplicity............. Not Always
Thanks Andy
When do I reset it. After closing the file or only at the end of the code?
Turning it back on after closing the file works. The message is not displayed anymore. Thanks.
Your welcome... Can you mark the thread solved please - It's under the thread drop down
Just for interest sake; How do I clear the clipboard?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks