RE: [ExcelVBA] Re: Freeze Window

 

If you have full control of your macro, then there is no problem. The
problem arises when your macro becomes a step in a series of macros.
Overall, the person who created the "master" macro wants screen updating
off, so when they get to your macro, you turn off screen updating (again)
when you start, but you turn it back on when you finish. The opposite
condition to what you started with.

It is just a matter of respecting the conditions you start with. As I said,
it is a minor point and most of the time, it does not matter.

John. Visio MVP

From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
Of noskosteve
Sent: July-21-11 11:22 PM
To: ExcelVBA@yahoogroups.com
Subject: [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?

[Non-text portions of this message have been removed]

__._,_.___

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

Messages in this topic (8)

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

.

__,_._,___