Disabling Screen Updating and running PP in background via VBA.

[Brian Reilly, MVP]

Victor, PPT VBA does not have a screenupdating=False method like
Excel. you have to invoke the Windows API to do this. I have been
successful in doing this in some situations and not in some other
situations., probably because I'm not passing variables correctly.
Most of my testing for this has been when running PPT as controlled
from Excel via VBA so that adds another variable.

but this should work,
Brian Reilly, PowerPoint MVP

On Wed, 15 Sep 1999 14:22:36 -0700, Victor Bennight
<victor.d...@lmco.com> wrote:

>Hello all,
>
> 1. Does anyone know or have had success with preventing screen
>updating in PowerPoint with VBA? Excel has the
>"Application.ScreenUpdating = True/False"
>but this does not work with PowerPoint. Any suggestions?
> 2. I think there is a method of running PowerPoint in the background
>while a VBA macro is executing, but I cannot seem to find where I saw
>this method. Does anyone have a clue as to how this might be done?
>
>Thanks to all for any insights or suggestions.
>
>Best regards,
>
>
>

[Victor Bennight]

[Victor D. Bennight]

Redux. I added a line to minimize the application window at the
beginning of the VBA code. This simple step, in lieu of
"Application.ScreenUpdating = msoFalse" which is NOT available in
PowerPoint 97 (I forgot to mention the version), cut the execution time
of the application by about 36 percent. In case you're interested, the
line is: "Application.WindowState = ppWindowMinimized".

This simple addition to the VBA code precludes the necessity for running
in the background.

I have had a wonderful time generating a PowerPoint application for
producing "crude" (in my view) Gantt Charts. If anyone is interested,
just send me a note requesting information.

Best regards,

[Steve Rindsberg]

Victor, if you'd like to post the info here, we'd be delighted to see it.

Victor D. Bennight <victor.d...@lmco.com> wrote in message
news:37E016A3...@lmco.com...

<snip snip>