Scrol bar how to move to right using button action ?

[paulyeo11]

Hi All

I have a table , there is a scrol bar it will alway move to left , may i know how to make it move to right by button action ?

[juleshartley]

HI,

I'm afraid this doesn't work from a button.. it will only work when opening the document. I think this is because it sets the starting position or something. Anyway, code is something like...

sub mcrScroll

          set chart = ActiveDocument.GetSheetObject("CH229784")

          set p = chart.GetProperties

          p.ChartProperties.XScrollInitRight = true 

          chart.SetProperties p

end sub

Hope that helps!

[paulyeo11]

Thank you very much for your advise.