Hello All,
I am trying to tie several graphs to various tables so that when a certain table is selected it activates the respective graph. I am currently performing this via a set of triggers under sheet properties.
This works very well with the exception that when I drop the tables into a container and click on the container tab it doesn't "activate" the table and so while the correct table is displayed it is not activated and therefore doesn't trip the trigger to show the correct graph.
What I'm looking for is a preference setting for making the container tab selection activate the respective sheet or a macro which will perform a similar action (though I am shying away from Macros).
I did manage to get this to work by adding transparent buttons over the tabs but I don't think this is a realistic solution given the number of these that I would have to create and manage as the file evolves.
Many Thanks,
CLive
