Trigger Macro on Project Status Drop Down

[Mr. Entropy]

Hi,

I would like to change the value of the "Publish "columm based on when a
user makes a choice for the "Project Status."

For example, when a user selects "In Progress" as the Project Status I would
like to set all tasks where percent complete does not equal 100% to Publish
equals "Yes."

I'm assuming a VBA macro is the way to achieve this functionality. Could
someone point me in the right direction?

Many thanks,
Carl

 

[Jack Dahlgren MVP]

There is nothing in VBA which would trigger off changing the project status
through a dropdown, but I''d probably just put a button on the toolbar which
changes the status for the project and sets the publish for all the tasks.

For how to run through all the tasks, take a look at the postings on my
blog:

http://zo-d.com/blog/archives/programming.html

-Jack

 

[Mr. Entropy]

Thank you very much, Jack! Your website looks like a great resource. I'll
start reading.

 

[Ben Howard]

In addition to Jack's posting (and excellent site), I published some VBA on
changing the task publish field where %comp = 100 -
http://appleparkltd.spaces.live.com/
--
Thanks, Ben.

Microsoft Most Valuable Professional
http://appleparkltd.spaces.live.com/

 

[Mr. Entropy]

Thank you, Ben! Very much appreciated! I will see if this solves our
requirement.

 

[Mr. Entropy]

Hi Jack and Ben,

One more question for you: how do you access the "Project Status" in VBA?

Thanks,
Carl

 

[Mr. Entropy]

Sorry for to create so many posts. I just realized "Project Status" is an
Enterprise Custom Field. Can it still be changed using VBA?