Hello, I have several Workbooks that I have made a Table of Contents (TOC) for. In the TOC I have a list of the worksheets that I manually create hyperlinks for. To do this I use two modules, one is called "List_Sheets" which will make a list of the worksheets in the workbook.The other one I use is "Auto_Open" which opens the TOC once you open the workbook.Please Login or Register to view this content.
I would like to be able to use VBA to automatically populate the hyperlinks into the listed worksheets. Below I have a mock workbook setup to show what I mean. Any help would be very appreciated.Please Login or Register to view this content.
Auto_Hyperlink_TOC.xls
Bookmarks