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.