Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 "jeromeB" wrote in message ... |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. |