Triggering a macro to run

[TESA0_4]

I have created a macro that highlights information to the user if certain
date criteria are breached. Is there a way in which I can set up Project so
that whenever a Start or Finish date for a task is modified the macro is
automatically triggered to run? Thanks if you can help.

 

[John]

I have created a macro that highlights information to the user if certain
date criteria are breached. Is there a way in which I can set up Project so
that whenever a Start or Finish date for a task is modified the macro is
automatically triggered to run? Thanks if you can help.

TESA0_4,
Well yes and no. What you are looking for is an event based macro and
setting one up is detailed on Jack's website at:
http://masamiki.com/project/macros.htm
However, event based macros are not all that reliable. There are so many
ways that the Start and Finish fields can change, the triggering event
may not always occur.

My suggestion, use the process outlined on Jack's site and see how it
works. If performance is sporadic, it may be possible to use a
combination of a customized field (detects the change) and a macro (to
monitor the result in the customized field). This approach may or may
not be more reliable - I've never tried it.

Hope this helps.
John
Project MVP

 

[TESA0_4]

Hi John,
Thanks for the answer. I'm a Project newbie so I will follow your advice and
see where it leads me. There is only a small user group for the application
so it will be easy to have people use a consistent way to play with the dates
that triggers the update.

 

[John]

Hi John,
Thanks for the answer. I'm a Project newbie so I will follow your advice and
see where it leads me. There is only a small user group for the application
so it will be easy to have people use a consistent way to play with the dates
that triggers the update.

TESA0_4,
You're welcome. When I said there are multiple ways fields can change I
wasn't referring to different users. Certainly users can manually modify
many of Project's fields, but some fields, and Start and Finish are good
examples, are calculated by Project based on many things. It is the
calculated changes that may or may not trigger the event you want.

John
Project MVP