Table of contents
TOC
Collapse the table of content
Expand the table of content

Application.SetSplitBar Method (Project)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

Positions the vertical split bar in a sheet view to display the specified number of columns.

Syntax

expression. SetSplitBar( ** ShowColumns** )

expression A variable that represents an Application object.

Parameters

NameRequired/OptionalData TypeDescription
ShowColumnsOptionalLongSpecifies the number of columns to display, including the locked ID column. The value can be 1 through 75. The default value is the total number of columns currently displayed, including any partially hidden column.

Return Value

Boolean

Remarks

If the right pane of the view has been sized so that there is no left pane, the SetSplitBar method has no effect.

If the split bar is partially hiding the right-most column, using the SetSplitBar method with no argument moves the split bar to show the complete column.

Example

If the standard Gantt Chart is the active view, the following statement sets the split bar to show only the ID, Indicators, Task Mode, and Task Name columns.

Application.SetSplitBar ShowColumns:=4
© 2018 Microsoft