hyperlink to Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear experts,
I would like to reference a chartsheet(S) where you can click to go
directly on that
charts).
I have done it for some worksheets with the "hyperlink" function, but this
does not work for charts...

I want do this for many charts (at many sheets) , but want the hyperlinks
resident at one sheet (like indexing)
 
It doesn't work because it's not been built to. You have to use code to
mimic the action of a hyperlink.

Or do you mean you tried the code and it didn't work?

Cheers
Andy
 
becouse i have many chart sheets , and i wanna make hyperlink to each chart
sheet at the one sheet , is that possible , and if possible would you olease
give me example for;
Many Thx for your time;
 
List all your chart sheets in the table of contents worksheet, and
adjust the code so it points to the entire range of chart names. If they
are listed in cells C3:C12, for example, change this line in the sample code

If Not Intersect(Target, Range("B2")) Is Nothing Then

to this

If Not Intersect(Target, Range("C3:C12")) Is Nothing Then


- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top