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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DisplayAlerts & ScreenUpdating Properties Changing Unexpectedly 4
Displayalerts and Screenupdating 4
Screenupdating=false not working 2
Need a little help coping a sheet from one workbook to another. 2
Can't Set DisplayAlerts to False 2
Calling a module from another module 5
ScreenUpdating not working 6
XL03: Avoid "workbook contains links" msg when opening 5

Back
Top