Position the Gantt chart divider bar

[Mark D]

How can I, by using a macro, set the position of the divider bar in the Gantt
chart, so that it always goes to that position when I run the macro.

I am using MS Project Professional 2003.

 

[Jan De Messemaeker]

Hi,

This is the help on the SetSplitBar method, which is what you need:

SetSplitBar Method
See AlsoApplies ToExampleSpecifics

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


Syntax

expression .SetSplitBar(ShowColumns)

expression Optional. An expression that returns an Application object.

ShowColumns Required Long. A number from 1 through 75 that specifies the number of columns to display, including the locked ID column. The default behavior is to position the vertical split bar to the right of the field that is closest to being fully displayed.


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

Greetings,

 

[Mark D]

Excellent! Thanks very much!

Hi,

This is the help on the SetSplitBar method, which is what you need:

SetSplitBar Method
See AlsoApplies ToExampleSpecifics

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


Syntax

expression .SetSplitBar(ShowColumns)

expression Optional. An expression that returns an Application object.

ShowColumns Required Long. A number from 1 through 75 that specifies the number of columns to display, including the locked ID column. The default behavior is to position the vertical split bar to the right of the field that is closest to being fully displayed.


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

Greetings,