Create a Table Of Contents With Hyperlinks In Excel Using VBA
Want to generate a Table of Contents or an Index as some may call it in your Excel workbook? It isn't as tough as it may seem at first. Put the below code in a standard code module and then execute. The code will generate a new sheet called Index, and generate an Index or a Table Of Contents with working Hyperlinks to all the worksheets. ------------------------------------------------------------------------------------- Sub HyperlinkWorksheetNames() 'Code by Deep Dave, make