DisplayAlerts -- How NOT to accept the default
Posted by Paulie on December 03, 2001 12:20 PM
If I make DisplayAlerts = False, a message that comes up such as:
"You have a large amount of data in the clipboard, etc. To save click Yes"
The default is YES
YES NO CANCEL
How would I get by this message screen and answer NO.
In other words, I do not want to accept the default.
Anyone know how to do this?
Posted by Ivan F Moala on December 04, 2001 1:44 AM
Just clear your clipboard
Sub Excel2K()
Application.CommandBars("Clipboard").FindControl(ID:=3634).Execute
End Sub
Sub Excel97()
Application.CutCopyMode = False
End Sub
Ivan
