View Full Version : Solved: DisplayAlerts

Howard Kaikow
04-29-2005, 03:13 AM
The Help for DisplayAlerts in Excel 2003 states:

The default value is True. Set this property to False if you don?t want to be disturbed by prompts and alert messages while a macro is running; any time a message requires a response, Microsoft Excel chooses the default response.

If you set this property to False, Micorosoft Excel sets this property to True when the code is finished, unless you are running cross process code.

When using the SaveAs method for workbooks to overwrite an existing file, the 'Overwrite' alert has a default of 'No', while the 'Yes' response is selected by Excel when the DisplayAlerts property is set equal to True.

However, when I set DisplayAlerts=False, the opposite effect occurs when I use SaveAs, which is what I want.

Is the documentation wrong?

04-29-2005, 01:56 PM
Interesting point. Just a few days ago I noticed the same thing when I was reading about Display Alert. Sadly, I haven't tested it to verify what they say. :bug:

Zack Barresse
04-29-2005, 03:01 PM
Is the documentation wrong?


Surprised? :think: Not hardly I think.

04-30-2005, 12:01 PM
Surprised? :think: Not hardly I think.
Not really no! :rofl: