Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Build a worksheet index with hyperlinks


posted by Nick Hodge
Tue, Jan 15 2008

Downloads: 163
File size: 53.5kB
Views: 663
Build a worksheet index with hyperlinks
Filed under: , , , ,

This workbook has a sheet of each type available in Excel. if you click on the 'Create Index' button, it adds a worksheet with the worksheet name, type and, if possible, a hyperlink to that sheet. It just a file by way of VBA demo. (Alt+F11 to look at code)

Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.