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..

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..

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..