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: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
Of mickey11030
Sent: July-21-11 10:04 AM
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA] Re: Freeze Window
Thanks all; that will be a big help.
--- In ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com> ,
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" <mickey11030@...>
>
> To: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com>
>
> Date: 07/21/2011 05:56 AM
>
> Subject: [ExcelVBA] Freeze Window
>
> Sent by: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com>
>
>
>
>
>
>
>
>
>
> 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]
>
[Non-text portions of this message have been removed]
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
----------------------------------
Tidak ada komentar:
Posting Komentar