DisplayAlerts and ScreenUpdate will not set to False

J

Joe at Baso

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
 
J

Joe at Baso

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?
 

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

VBA for Dependents shortcut menu 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Need a little help coping a sheet from one workbook to another. 2
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Dump ListBox Contents to Sheet & Stay on Active Sheet 0
Calling a module from another module 5
Macro Pause to Select range then Subtotal 0
vba code does not run 3

Top