How to know an alert should have displayed ...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set the DisplayAlerts property to false.
during the execution of my program, I want to know if an alert window should
have happened during the previous instructions if the DisplayAlerts property
was set to true.
Is it possible to get this status?

thanks.
 
Is it possible to get this status?

No it's not. The best you can do is be aware of the specific alerts that
can occur in the context of what the macro is doing. Say you have a macro
that does a File, Save As. You know that the "Overwrite existing file?"
alert will occur if a workbook with the intended name already exists.

--
Jim
|I have set the DisplayAlerts property to false.
| during the execution of my program, I want to know if an alert window
should
| have happened during the previous instructions if the DisplayAlerts
property
| was set to true.
| Is it possible to get this status?
|
| thanks.
 
Back
Top