View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default screenupdating command ignored

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