Lotus 1-2-3 {Windowsoff}

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top