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" wrote:

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