I have a 2d graph, i require a link,label or whatever on the graph that will take me to the place that i want. what i have done is, i had put a label control on the chart and directed it to a range that is behind the graph with the intention that it is not visible before and becomes visible only when i click the label, but that is not happening.
Is there any other alternative to this?
I have tried this on the label
Private Sub Label1_Click() ActiveSheet.Range("I14").Hyperlinks(1).Follow End Sub
Last edited by pike; 12-03-2011 at 12:33 AM. Reason: add code tags
Why do you need code? Does the hyperlink assigned to the shape not work?
Post a workbook to illustrate your problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks