Today's author is Dennis Wallentin, XL-Dennis, of http://xldennis.wordpress.com/ A few weeks ago we posted a code example for creating a table of contents for your workbook. Dennis offers another approach with this code sample for creating a TOC with hyperlinks. Dennis’ code uses the PageSetup.Pages().Count property, introduced in Excel 2007, to calculate the number of pages on each sheet. In addition, the entries in the TOC link to their respective sheets to improve on-screen workbook navigation
Read More...
Read the complete post at http://blogs.msdn.com/excel/archive/2010/04/30/creating-a-toc-with-hyperlinks-programmatically.aspx
Posted
Apr 30 2010, 02:02 PM
by
Microsoft Excel 2010