John
I have code at the bottom of this page
http://www.nickhodge.co.uk/vba/codeexamples.htm
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk
"John Pronk" wrote in message
...
I have an Excel workbook with many worksheets. How can I make a table of
contents in a sheet that picks up my worksheets?