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.