David McRitchie has lots of notes about doing this, he
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
Hope this helps.
Pete
On Nov 27, 1:29*am, Geoff W wrote:
Hi,
I want to insert a table of contents (as one would in MS Word) into Excel..
The TOC would be comprised of the worksheet names & hyperlinks to them.
Anybody got any ideas please?
Many thanks