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