View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default 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