Thread: ScreenUpdating
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
pls123 pls123 is offline
external usenet poster
 
Posts: 121
Default ScreenUpdating

tx all for help!


"Bob Phillips" wrote:

Help tells you that you should set it back to True at the end, but my
experience tells me it doesn't matter.

--

HTH

Bob

"pls123" wrote in message
...
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 !!!



.