4 Replies Latest reply: Jan 27, 2017 10:32 AM by Samane Ramezani RSS

    Setting Scrollbar to keep right by default in list box or straight table

    Samane Ramezani


      I have list box and a straight table in my document  and want to keep Scrollbar at right by default in those objects

      I found macro for line chart but did not work for list box or straight table

      the macro is :


      sub OneOff

      set chart = ActiveDocument.GetSheetObject("CH01")

      set p = chart.GetProperties

      p.ChartProperties.XScrollInitRight = true 

      chart.SetProperties p

      end sub



      Can anybody help me?