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
|