Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't Set DisplayAlerts to False
Windows XP, Excel 2003
After booting up, I put the following code in a module. Sub A() Application.DisplayAlerts = False Stop End Sub When the macro stops at the Stop statement, I type ?Application.DisplayAlerts in the immediate window and get the answer "True". It happens every time. I can't ever set DisplayAlerts to False in any macro at any time. Any ideas on what is wrong? Thank you. Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't Set DisplayAlerts to False
Mark
try it like this: Sub A() Application.DisplayAlerts = False MsgBox Application.DisplayAlerts Application.DisplayAlerts = True Stop End Sub Regards Trevor "Mark Driscol" wrote in message ... Windows XP, Excel 2003 After booting up, I put the following code in a module. Sub A() Application.DisplayAlerts = False Stop End Sub When the macro stops at the Stop statement, I type ?Application.DisplayAlerts in the immediate window and get the answer "True". It happens every time. I can't ever set DisplayAlerts to False in any macro at any time. Any ideas on what is wrong? Thank you. Mark |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't Set DisplayAlerts to False
This is because the displayalerts resets when the code finishes.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Mark Driscol" wrote in message ... Windows XP, Excel 2003 After booting up, I put the following code in a module. Sub A() Application.DisplayAlerts = False Stop End Sub When the macro stops at the Stop statement, I type ?Application.DisplayAlerts in the immediate window and get the answer "True". It happens every time. I can't ever set DisplayAlerts to False in any macro at any time. Any ideas on what is wrong? Thank you. Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DisplayAlerts and ScreenUpdate will not set to False | New Users to Excel | |||
Application::DisplayAlerts not working | Excel Programming | |||
application.displayalerts | Excel Programming | |||
DisplayAlerts property is not changing to False | Excel Programming | |||
EnableEvents and DisplayAlerts problems | Excel Programming |