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

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":
http://www.amazon.com/Programming-Microsoft-Project-Versions-Learning/dp/0975982877/ref=pd_bbs_sr_1?ie=UTF8&s=books&qid=1240954112&sr=8-1

Are you comfortable with a VBA solution?


James Fraser

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.

Thanks.