On sheet activate, want to kick off a trigger, what wrong with this?

[#1]

Good Afternoon,

I have a trigger that is used on document launch that sorts a combo chart to the most current selection on the x-axis.  This runs successfully on open. 

If I wanted this to also fire when the sheet the charts resides on was activated, I added this to the Sheet Properties Triggers.  However, on sheet activate this does not seem to work but on workbook activate it does.  Does anyone see what I am stupidly doing wrong?

The function is:

sub RightScroll1
set chart   = ActiveDocument.GetSheetObject("CH11")
set chartProperties = chart.GetProperties
chartProperties.ChartProperties.XScrollInitRight = true 
chart.SetProperties chartProperties
end sub 

Note, attached file has example.  If you look at the bar charts at the top of the first tab, when the document opens, the triggers seems to scroll the two charts to the right so the latest information is showing.  However, if I scroll one of the charts to the older data, then leave the sheet to goto the Calendar Table sheet tab, then return to the Set Analysis & Aggr & Rank tab, the two charts do NOT scroll all the way to the right again, why?   Note, I have triggers on the sheet on activate as well as on the document for open.  How do I fire the triggers on sheet activate to scroll successfully?

Thanks,

D

[jerrysvensson]

Hi

Are you doing his in Ajax v11?  If so, OnActivate sheet trigger doesn't work in Ajax.

[#3]

Do you know how to adjust the chart to the right on the scrollbar if the document has already been opened?

[#4]

Good question.  This is just in the windows client at this point. 

Not sure how to adjust x-axis scrollbar once opened, any ideas>?