Prev: Problems executing commands on one file from another
Next: insert a dash
From: pls123 on 5 May 2010 17:20
here again!
just to say that i notice a cpu saving
when i don't write
Application.ScreenUpdating = False
at the end of sub..
i'll make some test for stability now !
tx all byby !!


"pls123" wrote:

> Hi all !!
>
> when I use Application.ScreenUpdating = False
> at the beginning of a Sub,
>
> will it propagate to other subs thet are called by this first one,
> even if they are in other workbooks ,
>
> or i have to write it also in the called subs ??
>
> Does it makes any difference if I dont' write
>
> Application.ScreenUpdating = True
>
> at the end of this main sub in excel 2007 ??
>
> tx all !!!
First  |  Prev  | 
Pages: 1 2
Prev: Problems executing commands on one file from another
Next: insert a dash