Application.TimescaleNonWorking method (Project)
Sets the format of nonworking times.
Syntax
expression. TimescaleNonWorking( _Draw_, _Calendar_, _Color_, _Pattern_ )
expression A variable that represents an Application object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Draw | Optional | Integer | How nonworking times are denoted in relation to Gantt bars. Can be one of the following PjNonWorkingPlacement constants: pjBehind, pjInFront, or pjDoNotDraw. |
| Calendar | Optional | String | The name of the calendar to format. |
| Color | Optional | Integer | The color of nonworking times. Can be one of the PjColor constants. |
| Pattern | Optional | Integer | The pattern for nonworking times. Can be one of the PjFillPattern constants. |
Return value
Boolean
Remarks
Using the TimescaleNonWorking method without specifying any arguments displays the Timescale dialog box with the Non-working Time tab selected.
To set nonworking time format by using a hexadecimal RGB value for color, see TimescaleNonWorkingEx.
Example
The following example draws nonworking time behind the task bars in red.
Sub Timescale_NonWorking()
'Sets nonworking time behind the task bars to red.
'Activate Gantt Chart.
ViewApply Name:="&Gantt Chart"
TimescaleNonWorking Draw:=pjBehind, Color:=pjRed
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.