Table of contents for Charts
 

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

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

Andy,
Many Thanks exactly what I needed
Ajay

"Andy Pope" wrote:

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