KarenK
06-21-2007, 08:53 PM
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 -
JulieS
06-21-2007, 09:58 PM
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
--
Jack Dahlgren
Project Blog: http://zo-d.com/blog
Macros: http://masamiki.com/project/macros.htm
"docendo discimus"
"KarenK" <KarenBKing@gmail.com> wrote in message
news:07653F87-ACB5-4EDF-B30E-F11368E16A91@microsoft.com...
> 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 -
>
>
>