Lotus 1-2-3 {Windowsoff}
 

In Lotus 1-2-3 years ago there was a {Windowsoff} command to
"freeze" the screen while a macro is running. "Unfreezing" occurs
when {Windowson} is run/

What is the equivalent in Excel 2000?

TIA - Bob

Lotus 1-2-3 {Windowsoff}
 

Bob,

Application.ScreenUpdating = False
Turns it off
Application.ScreenUpdating = True
Turns it back on.
It'll aurtomatically turn itself back on when your macro ends, but it's
a good idea to turn it back on anyway at the end of your code.

John


"Bob Barnes" wrote in message
...
In Lotus 1-2-3 years ago there was a {Windowsoff} command to
"freeze" the screen while a macro is running. "Unfreezing" occurs
when {Windowson} is run/

What is the equivalent in Excel 2000?

TIA - Bob

Lotus 1-2-3 {Windowsoff}
 

John - Thank you.