When I use workbooks.close I can set the option SaveChanges to False, but I can't find the switch to prevent the message "Do you want to save clipboard contents to paste later?" from interrupting program flow. I did find a workaround - if you copy a single blank cell just before closing that replaces a big thing on the clipboard with a little thing that doesn't trigger the message. But I'd rather have cleaner code - what's the name of this switch?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SaveClipboard:=NoThanksAnd QuitAsking 1
- Thread starter bilojax
- Start date
-
1
- #3
TonyJollans
Programmer
Hi bilojax,
If you set Application.DisplayAlerts = False you will suppress the message and Excel will generate the default response - which is to keep data on the clipboard.
Enjoy,
Tony
If you set Application.DisplayAlerts = False you will suppress the message and Excel will generate the default response - which is to keep data on the clipboard.
Enjoy,
Tony
- Status