Application.SetSplitBar method (Project)
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
| 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
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
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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for