View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Driscol Mark Driscol is offline
external usenet poster
 
Posts: 18
Default 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