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
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
    LVL 13

    Expert Comment

    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

    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


    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


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    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…
    Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
    Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now