Hi all,

I have the following problem.

I have a fully dynamic VBA generated Spreadsheet.
It import raw data, sort them into Pivot Table then generate Graph in a newly generated Sheet.
Now here is my problem, I need to add a click action for when I click on a chart, the spreadsheet automatically move to the proper tab.

I tried to do it via Macro but while I get the code, if I change it, excel doesn't take my modification.
I would like to keep button as a last solution as I don't want to pollute my graphs with extra object.

By the way, is there any way to "fix" a chart to the Sheet so user can't move them accidentally? And obviously not impact on the function above?

Thank you in advance.