8 Replies Latest reply: Jun 25, 2014 2:06 AM by sujeetsingh RSS

Setting Scroll Bar to default to the right

spb

In the attached chart I am trying to figure out how to set the scrollbar to default to the right.

 

How do you enable or insert a macro such as:

sub OneOff

set chart = ActiveDocument.GetSheetObject("CH23")
set p = chart.GetProperties
p.ChartProperties.XScrollInitRight = true
chart.SetProperties p

end sub