DisplayAlerts and ScreenUpdate will not set to False

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Excel using VBA code Application.DisplayAlerts = False or
Application.ScreenUpdating = False. I F8 step thru the code and watch the
value of DisplayAlerts. It never reads False. Seems like it worked
yesterday? Is there any setting that would stop this from working?

Joe
 
More info. I had been looking at DisplayAlerts as I stepped thru the code by
placing the mouse curser over the word DisplayAlerts and always said "True".
I just used temp = application.DisplayAlerts and debug.print temp and that
reads out "False"? So new question. Why?
 
Back
Top