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