Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink to a chart
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink to a chart
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink to a chart
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 "Andrea Jones" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlink to chart | Excel Discussion (Misc queries) | |||
Hyperlink from Organisation chart box | Excel Discussion (Misc queries) | |||
Hyperlink ? - forgot to add it's a chart | Excel Worksheet Functions | |||
hyperlink to Chart | Charts and Charting in Excel | |||
Hyperlink to a chart... | Excel Discussion (Misc queries) |