Re: Screen updating in VBA

Article View: microsoft.public.powerpoint

Article #10

Back to microsoft.public.powerpoint Previous Next

#10

From: davstein
Date: Thu, 09 Sep 1999 00:00

41 lines
2016 bytes

I've seen a work around that actually minimizes the entire PowerPoint
application, performs the task, and then maximizes it at the end of the
macro.

Try:
    Application.WindowState = ppWindowMinimized
    <insert macro here>
    Application.WindowState = ppWindowMaximized

it'll scare the hell out of the operator the first time it runs, but
with proper training and en explanation, they'll be fine with it.

David

In article <37D6C9BE.5870B67E@lmco.com>,
  Victor Bennight <victor.d.bennight@lmco.com> wrote:
> Graeme,
>     Have you had a favorable response to your quer?  I'm in the same
> boat.  I have a moderately sized PP application which runs from VBA.
> Turning off screen updating would speed up the execution by a factor
of
> at least five or six (I think).
>   I haven't had any luck on finding any good info on turning su off.
MS
> is not much help in this regard.
>
>     Thanks in advance.
>     Victor D. Bennight
>
> Graeme Silk wrote:
>
> > Anyone know how to turn screen updating off for PowerPoint VBA?
> > screen.Updating=False does not seem to work.
> >
> > Thanks
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.

Technical Details

Message-ID: <7r8tav$p48$1@nnrp1.deja.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <7l5md4$6ad$1@news3.saix.net> <37D6C9BE.5870B67E@lmco.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f9f09,53127019bb194de0
X-Google-Attributes: gidf9f09,public
X-Google-Thread: faa5d,53127019bb194de0
X-Google-Attributes: gidfaa5d,public
From: davstein@my-deja.com
Subject: Re: Screen updating in VBA
Date: 1999/09/09
Message-ID: <7r8tav$p48$1@nnrp1.deja.com>
X-Deja-AN: 523024470
References: <7l5md4$6ad$1@news3.saix.net> <37D6C9BE.5870B67E@lmco.com>
X-Http-Proxy: 1.0 x25.deja.com:80 (Squid/1.1.22) for client 198.240.130.164
Organization: Deja.com - Share what you know. Learn what you don't.
X-Article-Creation-Date: Thu Sep 09 18:13:01 1999 GMT
X-MyDeja-Info: XMYDJUIDdavstein
Newsgroups: microsoft.public.powerpoint,fj.comp.applications.powerpoint
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT)

Reply to Parent Message