Suppress display while running a macro

K

KarenK

Is there a command to turn off the screen activity while a macro is running?
We have one that applies a series of filters and acts on the filtered
results, and would rather just see the finished product, not all the screen
flashes and refreshes.
Thanks -
 
J

JulieS

Answer copied from microsoft.public.project newsgroup for people
searching this newsgroup:
---------------------------------------------------------
There are a couple of things you can do:
First set project calculation to manual. This will stop project from
recalculating during the execution of the macro. Turn it off by:

OptionsCalculation Automatic:=False
Then turn it on at the end
OptionsCalculation Automatic:=True

The other thing is to turn off screen updating:

MSProject.ScreenUpdating = False
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top