Hi,

I have been successfully using Application.Screenupdating = false
before running my code and Application.Screenupdating = true after to
get the macro to run faster.

Suddenly Application.Screenupdating = false doesn't work anymore.
After running that line of code checking the value of
Application.Screenupdating gives you true! So it always keeps it true.
I can change the value to flase in the immediate pane. It changes but
then running any other line of code from the macro resets it to true.

Please help me fix this. All my macros are now running soooo slowly.
Thanks

Note :The only change I remember making was setting the ignore other
applications options in the general tab but I've removed that now and
still it doesn't work.


--
modjoe23
------------------------------------------------------------------------
modjoe23's Profile: http://www.excelforum.com/member.php...o&userid=26376
View this thread: http://www.excelforum.com/showthread...hreadid=401555