Application.LevelingOptions method (Project)

Specifies leveling options for the active project.

Syntax

expression. LevelingOptions( _Automatic_, _DelayInSlack_, _AutoClearLeveling_, _Order_, _LevelEntireProject_, _FromDate_, _ToDate_, _PeriodBasis_, _LevelIndividualAssignments_, _LevelingCanSplit_, _LevelProposedBookings_ )

expression A variable that represents an Application object.

Parameters

Name	Required/Optional	Data type	Description
Automatic	Optional	Boolean	True if Project automatically levels tasks in the active project.
DelayInSlack	Optional	Boolean	True if the active project can be leveled only within the available slack time. False if the project can be delayed in order to level resources.
AutoClearLeveling	Optional	Boolean	True if Project clears old leveling values before leveling.
Order	Optional	Long	A constant that specifies how Project should resolve resource conflicts when leveling tasks in the active project. Can be one of the PjLevelOrder constants.
LevelEntireProject	Optional	Boolean	True if the entire project is leveled. False if only the resources in the date range specified with FromDate and ToDate are leveled.
FromDate	Optional	Variant	The starting date of a range within which overallocated resources are leveled. The FromDate argument is ignored if LevelEntireProject is True.
ToDate	Optional	Variant	The ending date of a range within which overallocated resources are leveled. The ToDate argument is ignored if LevelEntireProject is True.
PeriodBasis	Optional	Long	Specifies how often Project should look for overallocated resources. Can be one of the PjLevelPeriodBasis constants.
LevelIndividualAssignments	Optional	Boolean	True if leveling can adjust individual assignments on a task.
LevelingCanSplit	Optional	Boolean	True if leveling can create splits in remaining work.
LevelProposedBookings	Optional	Boolean	True if leveling includes proposed resource bookings.

Return value

Boolean

Remarks

If an argument is omitted, its default value is specified by the current setting in the Resource Leveling dialog box.

Using the LevelingOptions method without specifying any arguments displays the Resource Leveling dialog box.

To include manually scheduled tasks in the leveling options, use the LevelingOptionsEx method.

Example

The following example levels resources in the application using priority to resolve conflicts.

Sub LevelOverallocatedResources() 
 LevelingOptions Order:=pjLevelPriority 
 LevelNow (True) 
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.