Application.SetSplitBar method (Project)

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


expression. SetSplitBar( _ShowColumns_ )

expression A variable that represents an Application object.


Name Required/Optional Data type Description
ShowColumns Optional Long Specifies 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



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.


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

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.