Application.ToggleTPResourceExpand method (Project)
Expands or collapses the specified resource row in the Team Planner view, when there is more than one assignment within the same time span for the resource.
expression An expression that returns an Application object.
|ResourceUniqueID||Optional||Long||Unique identification number of the resource.|
You can manually expand or collapse the list of tasks for a single resource, by choosing the + or ? icon next to the resource name. To do the same action for all resources, use the ToggleTPAutoExpand method.
The + or ? icon does not show next to the resource name if there are no overlapping assignments for that resource.
The ToggleTPResourceExpand method corresponds to the Expand Resource Rows check box on the Format tab under Team Planner Tools in the ribbon, but affects only the specified resource.
In the following example, the R2 resource has overlapping assignments. The ToggleTheResourceRow macro switches to the Team Planner view and expands or collapses the row for R2. When the row is expanded, it is easier to see all of the overlapping assignments.
Sub ToggleTheResourceRow() Dim resourceUid As Long ViewApplyEx Name:="Team Planner" resourceUid = ActiveProject.Resources("R2").UniqueID ToggleTPResourceExpand (resourceUid) End Sub
Support and feedback
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.