Table of contents for Charts

[Guest]

Morning All,
Currently using the code from dmcritchie's site to build table of contents
works very well, however tried it for the first time this morning with a
workbook full of charts only and the hyperlink doesnt work.
What am I doing wrong or do I have to adapt it?
TIA
Ajay

 

[Andy Pope]

Hi,

If those are chart sheets then you can not hyperlink to them.
You would need to use VBA, see Jon Peltier's page for further instructions.
http://peltiertech.com/Excel/Hyperlinks.html

Cheers
Andy

 

[Guest]

Andy,
Many Thanks exactly what I needed
Ajay

Hi,

If those are chart sheets then you can not hyperlink to them.
You would need to use VBA, see Jon Peltier's page for further instructions.
http://peltiertech.com/Excel/Hyperlinks.html

Cheers
Andy