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

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