Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't Set DisplayAlerts to False
Sorry, I can't see my original post. There was one repy as follows. Can
anyone tell my why this would indicate that Application.DisplayAlerts gives "False," but my original one (checking via the Immediate Window) gives "True"? Thanks. 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 news:... 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
when you exit the routine (through the stop) DisplayAlerts is automatically reset. Regards Trevor "Mark Driscol" wrote in message ... Sorry, I can't see my original post. There was one repy as follows. Can anyone tell my why this would indicate that Application.DisplayAlerts gives "False," but my original one (checking via the Immediate Window) gives "True"? Thanks. 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 news:... 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 | |||
Can't Set DisplayAlerts to False | Excel Programming | |||
application.displayalerts | Excel Programming | |||
DisplayAlerts property is not changing to False | Excel Programming | |||
EnableEvents and DisplayAlerts problems | Excel Programming |