Lotus 1-2-3 {Windowsoff}

[Bob Barnes]

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

 

[John Wilson]

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]

John - Thank you.