Anyone know how to hyperlink to an Excel chart page? Not to a normal worksheet, which is pretty easy, but rather to those specialized chart pages the chart wizard creates.
Thanks much.
Logos
Hi Logos,
Strictly speaking, a hyperlink will not link to a Chart sheet. The same effect can be accomplished via a simple macro. You didn't mention WHAT you want to hyperlink, so I will assume it is a Shape object for this example (textbox, rectangle, etc.). Simply right-click on the Shape, select Assign Macro, select New, and then insert
Charts("Chart1").Activate
into the macro that appears. It should then be something like
Sub AutoShape1_Click()
Charts("Chart1").Activate
End Sub
Now you should be able to click on the Shape and go directly to the chart.
Keep Excelling.
Damon
VBAexpert Excel Consulting
LinkedIn Profile http://www.linkedin.com/pub/damon-ostrander/7/79/a93
AllExperts Profile http://www.allexperts.com/ep/1059-30...-Ostrander.htm
Like this thread? Share it with others