[ExcelVBA] Re: Freeze Window

 

John,

I do this all the time and don't understand your tip. Since I am in control of my macro and updatinog, I turn it off when a long macro is doing screen ops, then turn it on when the macro finishes - this way it runs faster, then, I see the results when it finishes.
Even if it was off to start, I still want to see the results.
Steve

--- "VisioMVP" <VisioMVP@...> wrote:
>
> One minor point. Rather than setting ScreenUpdating to True at the end, you
> should save the current state and then restore it when finished. If
> ScreenUpdating is false before you start, then you would be altering things.
>
> John. Visio MVP
>
> From: mickey11030>
> Thanks all; that will be a big help.
>
> --- William D Simpson <w-simpson1@> wrote:
> >
> > Application.ScreenUpdating = False '.to stop screen updating
> > Your code here
> > Application.ScreenUpdating = True '..to allow screen updating

> > Regards, Bill Simpson PMO Emerging Programs 972-952-2573

> > From: "mickey11030"

> > I seem to remember hearing about a command to stop the window from
> updating
> > to speedup a long running macro. Does anyone remember what that command
> is?

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (6)

Recent Activity:

• New Members 8

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___