select chart vba

[orsm6]

Hi all - I am scratching my head on this one. My boss made a document that has easily 50 or so chart sheets. He made a portal page with buttons to jump from chart to chart and back to portal to make it easier. somehow, all of the names he gave the sheets have reverted back to saying Chart1, Chart2 etc etc...

I had to then fix the macros. but now a few weeks later all of the macros are not working again and the Chart Sheet names have changed again... now Chart1 and somehow changed to Chart89, then Chart90 etc etc.

I did some googling to see if I could just activate the chart only by object... not the sheet name.

this is the code i used:

Sub Plant_GE_Weekly(): Charts(3).Activate: End Sub

but i have run into a problem.
when i assign the macro above to Object Chart3 (Chart89) it for some reason takes me to Chart18 (Chart91)


why would that be?

 

[Domenic]

Charts(3).Activate

The above code refers to the chart sheet by index number, that being the 3rd chart sheet in the collection. So, let's say that you have 3 chart sheets, and they're named Chart89, Chart90, Chart91, and that they are in that order. In this case, Charts(1) refers to Chart89, Charts(2) refers to Chart90, and Charts(3) refers to Chart91.