This content has been marked as final. Show 3 replies
I'm not sure if this is possible, but what I'd like to do is to assign a trigger to a specific object (a bar chart) so that if a selection is made within this chart, a different sheet is activated.
I can't assign a trigger to the field, as I have a list box on the sheet containing the field in question, and I don't want to activate another sheet if a selection is made from the list box.... only if the selection is made within the bar chart.
Any suggestions would be hugely appreciated!