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

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