Hi
It automatically sets to true at the end of each sub (otherwise your
screen would not update). Worthwhile putting it at the top of every
sub.
regards
Paul

On May 5, 7:02*pm, 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 !!!