ScreenUpdating
in [Programming]
|
From: pls123 on 5 May 2010 14:02 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 !!!
From: Paul Robinson on 5 May 2010 14:34 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 <pls...(a)discussions.microsoft.com> 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 !!!
From: Bob Phillips on 5 May 2010 14:36 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" <pls123(a)discussions.microsoft.com> wrote in message news:A2F7D924-8EA9-48AC-8BE1-5D903E21CF4D(a)microsoft.com... > 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 !!!
From: Bob Umlas, Excel MVP on 5 May 2010 15:00 You don't need to have applicatino.screenupdating=false throughout -- only once will suffice. However, I do recomment turning it to true at the end - I've frequently seen the entire app seep to freeze until I went to the immediate window and entered Application.Screenupdatin = True (after the macro had stopped!) in order to even see the worksheet. "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 !!!
From: pls123 on 5 May 2010 15:45 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" <pls123(a)discussions.microsoft.com> wrote in message > news:A2F7D924-8EA9-48AC-8BE1-5D903E21CF4D(a)microsoft.com... > > 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 !!! > > > . >
|
Next
|
Last
Pages: 1 2 Prev: Problems executing commands on one file from another Next: insert a dash |