5 Replies Latest reply: Feb 23, 2012 1:08 AM by Gyan Prakash Srivastava RSS

Setting Scroll Bar to default to the right


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