| 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.. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Application.ScreenUpdating = False
TY J
i turn it true at the end of the main macro... but it worked fine (updating the videoprint) also without.. now..do you know if i should downgrade to excel2003 for beter performance or.. the problem was just that 1 ??? i need to run the more possible pages at the same time.... last question..my workbooks don't run on dual core..even if the option is normally enabled... (it just can't go over 50% cpu usage )) is vere any thing to know about ?? ty paolo "JBeaucaire" wrote: 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 | |||
Linear Mode
