| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Lotus 1-2-3 {Windowsoff}
John - Thank you.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lotus 123 (wk4) | Excel Discussion (Misc queries) | |||
| Lotus to Excel to Lotus | Excel Discussion (Misc queries) | |||
| confused on lotus | New Users to Excel | |||
| lotus 1-2-3 with .123 ext | Excel Discussion (Misc queries) | |||
| converting from lotus 123 | Excel Worksheet Functions | |||
Linear Mode
