In the Schedule section on the right side of the screen, hover over the predecessor task bar until a circle appears at either edge.In the project workspace, click the Gantt tab.If you don't see the project for which you want to manage tasks in the Recent Projects section, click All Projects and locate it in the Project List. Hover over Projects on the left-side nav bar, and select your project.To establish a dependency in the Schedule, just connect a line between the start or end dates of the predecessor and successor task bars. Start to Finish ( SF)-The predecessor begins before the successor can end.ĭependencies can be managed from the Local Gantt in both the Tasks list and the Schedule.Finish to Finish ( FF)-The predecessor ends before the successor can end.Start to Start ( SS)-The predecessor begins before the successor can begin.Finish to Start ( FS)-The predecessor ends before the successor can begin.
Before you begin establishing dependencies, it’s important to understand that there are four types: Tasks may have multiple predecessors or multiple successors. The successor, by contrast , is the task whose start or end date is controlled by the predecessor.Ī dependency is the relationship between predecessor and successor tasks. There are two steps to creating a dependency-first, identify the predecessor and successor tasks and then establish a relationship between them.īy definition, the predecessor is the first task it controls the start or end date for all related successor tasks. Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.In the Local Gantt chart, dependencies allow you to define relationships between tasks and visualize the sequence in which they must be completed in order to close a project. PathDrivenSuccessor Property PathPredecessor Property PathSuccessor Property Support and feedback Nameĭebug.Print vbTab & chkTsk.Name & ": PathPredecessor"ĭebug.Print vbTab & chkTsk.Name & ": PathDrivingPredecessor"ĭebug.Print vbTab & chkTsk.Name & ": PathSuccessor"ĭebug.Print vbTab & chkTsk.Name & ": PathDrivenSuccessor"įor the project in Figure 1, if the Predecessors, Driving Predecessors, Successors, and Driven Successors items are all selected in Task Path, the TestTaskPath macro has the following output: Selected task ID 1, name: T1 If Not (ActiveSelection.Tasks Is Nothing) Thenĭebug.Print "Selected task ID " &. Option ExplicitĪpplication.SelectRow Row:=selectedTaskId, RowRelative:=False The TestTaskPath macro selects each task in a project, and then uses the four task path properties in turn to show how the other tasks relate to the selected task. Project does not have a VBA method that can set items in the Task Path drop-down list. However, if the Driving Predecessors item is not selected, the previous statement prints False. ? ActiveProject.Tasks(1).PathDrivingPredecessor For example, if you select the third task as in Figure 1, and the Driving Predecessors item is selected in Task Path, the following statement prints True in the Immediate window of the VBE. You can manually select a task or use VBA to select a task, and then use VBA to check whether another task is a driving predecessor to the selected task. Instead, the PathDrivingPredecessor property is True whenboth of the following conditions are true: (a) the task is a driving predecessor of the selected task, and (b) the Driving Predecessors item is selected in Task Path. The PathDrivingPredecessor property does not act like the Driving Predecessors selection in the user interface. Using the task path properties to highlight tasks When you select T3, the Gantt Chart shows that T1 is a driving predecessor task and T4 is a driven successor task.įigure 1. In Figure 1, the Driving Predecessors and Driven Successors items are selected in the Task Path drop-down list. Task path is primarily a formatting feature in the Project client, where tasks in the Gantt chart have colors that depend on the current task selection and the relationship of a specified task to the selection. The Task.PathDrivingPredecessor property is related to the Driving Predecessors item on the Task Path drop-down list, on the FORMAT tab, under GANTT CHART TOOLS on the ribbon. SyntaxĮxpression A variable that represents a Task object. Gets a value that indicates whether the task is a predecessor that drives the selected task, when the Driving Predecessors item is selected in the Task Path drop-down list.