Table of contents for Charts

Ajay · Jan 6, 2005

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 · Jan 6, 2005

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

Ajay · Jan 6, 2005

Andy,
Many Thanks exactly what I needed
Ajay

Andy Pope said:
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