title | keywords | f1_keywords | ms.service | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
---|---|---|---|---|---|---|---|---|---|
Application.SetSplitBar method (Project) |
vbapj.chm31 |
|
project-server |
|
caf26a56-43ad-1714-79e4-cab013a55f3c |
06/08/2017 |
medium |
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. |
Boolean
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
[!includeSupport and feedback]