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