Jason --
Right up front, I can tell you there is NO way to create a custom field and
formula to determine the uncompleted Predecessors. And I suspect that
writing a macro in VBA would be exceptionally challenging as well. If you
are open to a little manual analysis, I can give you a technique that should
speed up the analysis process. Here's how: create a custom View called
_Dependency Analysis (or something like that). To create this custom View,
complete the following steps:
1. Open the project in question.
2. Click View - More Views.
3. In the More Views dialog, click the New button.
4. In the New View dialog, select the "Combination view" option and click
the OK button.
5. In the View Definition dialog, enter the name of the new View in the
Name field.
6. Click the Top pick list and choose the Gantt Chart view.
7. Click the Bottom pick list and choose the Relationship Diagram view.
8. Select the "Show in menu" option and click the OK button.
9. Click the Apply button to apply the new View.
10. In the top pane (Gantt Chart), select a task whose Predecessors you
want to investigate.
You can do the preceding set of steps, in any version of Microsoft Project,
including the 2000, 2002, 2003, and 2007 versions. When you select a task
in the top pane, the bottom pane shows you all of the IMMEDIATE Predecessors
and Successors for the selected task. You can now scroll through the Gantt
Chart to examine the status of the immediate Predecessors, following the
information you see displayed in the lower pane. The limitation of this
process is that the bottom pane only shows immediate Predecessors; it does
not show all Predecessors.
Hope this helps, even if only a little.
