screenupdating command ignored

[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

 

[Tom Ogilvy]

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.

 

[BrianB]

Screenupdating is automatically reset to True when the macro stops running.

Regards
BrianB
==========================================================