Hi,
Fairly easy one I think?
Want to assign a macro to a chart that hyperlinks to another worksheet when I click on the chart.
Anyone know what the code for this would be?
Cheers
Steve
Hi,
Fairly easy one I think?
Want to assign a macro to a chart that hyperlinks to another worksheet when I click on the chart.
Anyone know what the code for this would be?
Cheers
Steve
Hi _W0lf_,
For a chart object you can assign a macro.
Hold the shift key down whilst selecting the chartobject. Right click and assign a macro.
For a chartsheet you should be able to call the macro from an event, Chart_Select, for instance.
Or did you want something on the chart to provide and display the link.
The macro code needed would be something like;
worksheets("MySheet").activate
Cheers
Andy
Cheers for that Andy,
But what I am looking for specifically is the VBA code:
Figured it out...
Worksheets(Index).Activate
Knew it was easy ...
Laterz
Steve
Don’t have an account yet? Register yourself now and be a part of our community!