Hide all windows while macro is running
This definately did the trick for me! Seaching for 'screenupdating' didn't
turn up a thing in Excel 2003, though!
"Gary Keramidas" wrote:
all i've ever needed is:
Application.ScreenUpdating = False
at the beginning of the code and
Application.ScreenUpdating = true
at the end.
--
Gary
"Freddy" wrote in message
...
My current module opens multiple workbooks, saves them, prints them, then
closes them. My intention is to have all this happen but not see it happening
in the background. I only want to display a status bar message stating that
the macro is running (I have the code to display a status bar message). Any
suggestions?
|