Hyperlink to a chart

[Sarah G]

I have a workbook with multiple charts as their own worksheets. I have a
navigation page in which i wish to put hyperlinks to the various charts
however, when I go to the hyperlink window it does not recognise the charts
as worksheets therefore I cannot select them to bookmark or link them.
I would appreciate any assistance. Thank you

 

[Andrea Jones]

It's probably easier to add a button off the control toolbox and edit its
code to the following (change Chart1 to whatever your chart sheet is called)

Private Sub CommandButton1_Click()
ActiveWorkbook.Sheets("Chart1").Select
End Sub

Andrea Jones
www.stratatraining.co.uk

 

[Sarah G]

Thank you for that. Just a little more help please
Which words do I substitute with the actual names eg do I substitute
ActiveWorkbook with the actual name of the workbook. In the chart name do I
use the name of the chart Chart2 or do I substitute the name of the worksheet
that it is on
Private Sub CommandButton1_Click()
ActiveWorkbook.UtilisationMAR08("Chart2").Select