screenupdating command ignored

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

Hi

My line "application.screenupdating=false" is processed,
but the value is still true afterwards. I'm not connecting
to any databases or anything like that. Just working
within excel 2000. Any ideas why I can't turn it off?

Later
Bruce
 
You do

Application.ScreenUpdating = False
msgbox Application.ScreenUpdating

and you get True?

If you mean the screen updates somewhere after you set it to false, use code
like the above to find out where it changes back to true. I suspect you are
calling some built in routine (Perhaps in the analysis toolpak) that is
changing it back to true.
 
Screenupdating is automatically reset to True when the macro stops running.

Regards
BrianB
==========================================================
 
Back
Top