How to display if all predecessors are 100% completed or not. i.e. a task is ready to proceed or not in MSP web access

Posted on 2009-04-26
Medium Priority
Last Modified: 2013-11-15
Task A is predecessor of Task B
i want "ready to proceed" or "not ready to proceed" flag in a customized column for:

1) If Task A is 100% complete, customized column should give value "Ready to proceed" for Task B.

2) If Task A is < 100% complete, customized column should give value "Not Ready to proceed" for Task B.
As soon as the task manager of Task A updates the % completion status of Task A as 100%, the task manager of Task B should get value of "Ready to proceed" on MS Project 2007 web access system

Thanks in advance.
Question by:Nishant_Bhagwat
  • 2
  • 2
LVL 13

Expert Comment

ID: 24255351
You won't be able to do this with just a calculated field. To get your desired result, you will need to use VBA/macros.

One of the complications will be that tasks can have multiple predecessors that you need to check.

I'd guess that a macro to loop through a project and set these fields appropriately will be between 50 to 100 lines: not too complicated.

A great starting point for this macro would be the TaskLinks Macro (Module 24) from Rod Gill's "VBA Programming for Microsoft Office Project":

Are you comfortable with a VBA solution?

James Fraser

Author Comment

ID: 24261938
James, thanks for reply.

I am not a programmer but with a little struggle, I have now written a macro to do this successfully. But have to run the macro each time when I make changes to % completion field.

1) Is there any function in VBA for MS Project 2007 which will trigger the macro automatically as soon as % completion field is altered?
2) We have MS Project server too. Can we set my VBA scrip (my macro) to run automatically after a certain interval (let's say after each 8hrs) on my MS Project file or on the server database?

Thank you.
LVL 13

Accepted Solution

jbfraser earned 1500 total points
ID: 24262077

Question 2) first:
Your macro needs to run in Project, the client. It can't run in/on the server. The server does not support VBA.

Question 1):
You can connect this VBA code to different events. You can't narrow down to the % change event, but you could use the project or tasks change events, which will run the code on any change. The problem will be that this may slow project down considerably, depending on the size of your project.


James Fraser

Author Closing Comment

ID: 31574646

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question