Hyperlink to Sheet created by Moving Chart - Problem

[ashfire]

Ive created plenty of charts in excel 2007 and Move Chart – New sheet. These are then referenced in a powerpoint show with no problem.

Because I want to quickly move to a chart ive created a dashboard with a shapes and which I want to hyperlink to the relevant chart.

However when I tr to insert a hyperlink to place in this document none of the graph sheets are available. (all sheets that were created normally are)


Is there a way around this ?


cheers

 

[Hui]

Ashfire

There is no way to directly do what you want

There is a work around

insert a macro like below on a module page

[pre]

Sub Shape1_Click()
Charts("Chart1").Activate
'Change the Chart name to suit
End Sub

[/pre]

Then right click on your shape and Assign a Macro to your shape

Select the macro name you just pasted


You can make the Shapes Text Blue and Underline to make it look like a Hyperlink

 

[ashfire]

Brilliant, thank you very much