Basically I need a button on sheet SH01 that when clicked it takes the user to sheet SH02 and calls up, activates, a specific pie chart CH01 which is located within a container CT01. The container also has multiple objects within it, tables, charts etc... it has the tabs for the objects as a list dropped down from the top.
I have the following actions set up on the button on sheet SH01:
Activate Sheet SH02
Activate Object CT01
Activate Object CH01
I've tried multiple variations on this with no success activating the CH01 chart ...
We're on version 11 - version 11.20.11922.0 SR2 64 bit