I just read the following Mr. Excel tip: http://www.mrexcel.com/tip017.shtml about a macro to create a table of contents. It works great, but is it possible to add additional vba to automatically generate a hyperlink on the TOC tab? Meaning, once the sheet names are listed in the TOC tab, each of those names automatically becomes a hyperlink to its corresponding tab. Thank you.