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 wrote:
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, Microsoft MVP - Excel
http://www.andypope.info