Moving scroll bar to right

[#1]

Hi

I have requirement that the scroll bar in the chart has to be moved far right whenever the sheet is activated , but some how it does not work.It works only when the document os open , I using a macro to run this,

Attached is the app ...any inputs appreciated.

Thnk you