Turn off Page Flashing In Macro

Posted by Mark on November 25, 2001 5:57 PM

I have several macros that require the program to switch sheets and locations on a sheet and then return to the location where I invoked the macro. Several people have complained about the sheet "flashing" during execution of the macro. Is there a way to turn off the "flashing" during the execution of the macro?

Thanks -

Posted by jaime on November 25, 2001 6:09 PM

application.screenupdating=false

then @ the end of the macro

application.screenupdating=true

Posted by Noir on November 26, 2001 12:54 PM

:I had the same problem, thanks Jamie!!!!!
-noir