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/
_______
Chetoos wrote:
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;
"Chetoos" wrote:
Hello Andy;
Yea , the second one , i tried the code and doesn work ; donno why
"Andy Pope" wrote:
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
Chetoos wrote:
I donno why it doesnt work ? :S
"Andy Pope" wrote:
Hi,
You can not hyperlink directly to chart sheets. You can use VBA code
though. Jon Peltier has more information on the subject.
http://peltiertech.com/Excel/Hyperlinks.html
Cheers
Andy
Chetoos wrote:
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)
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info