| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.ScreenUpdating = False
hi all !!!
i wanted to know something about this command... Application.ScreenUpdating = False it seems to give less cpu usage on my multiple workbook on excel 2007.. should i use it for my macros ??? if there is a macro that launches other macros... is enough that it is indicated in the first macro , or it must be indicated in each launched macro?? ty.. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Application.ScreenUpdating = False
In the first macro is enough, but remember to turn it back on...
Application.ScreenUpdating = False MacroToRun Application.ScreenUpdating = True When the MacroToRun completes, the system will return to where you left off on the first macro. You could actually run several macros. -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "pls123" wrote: hi all !!! i wanted to know something about this command... Application.ScreenUpdating = False it seems to give less cpu usage on my multiple workbook on excel 2007.. should i use it for my macros ??? if there is a macro that launches other macros... is enough that it is indicated in the first macro , or it must be indicated in each launched macro?? ty.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to set Application.ScreenUpdating = False for Gen use | Excel Discussion (Misc queries) | |||
| Using the Application.ScreenUpdating = False? | Excel Programming | |||
| Using the Application.ScreenUpdating = False? | Excel Programming | |||
| Application.screenUpdating = False | Excel Programming | |||
| Application.ScreenUpdating = False | Excel Programming | |||
Hybrid Mode
