You can just hyperlink to a place on the spreadsheet by selecting the
"Place in this document" on the hyperlink pop up form. Then when you
make the table  of contents  use the line Worksheets("table of
contents").Activate under the workbook_open sub