MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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()
End Sub

Sub Excel97()
Application.CutCopyMode = False
End Sub