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.

--
Regards,
Tom Ogilvy

"Bruce" wrote in message
...
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

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

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


"Bruce" wrote in message ...
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