Today's author is MVP Bill Jelen of MrExcel.com . The following code example verifies that a sheet named "TOC" already exists. If it exists, the example updates the table of contents. Otherwise, the example creates a new TOC sheet at the beginning of the workbook. The name of each worksheet, along with the corresponding printed page numbers, is listed in the table of contents. To retrieve the page numbers the example opens the Print Preview dialog box. You must close the dialog box
Read More...
Read the complete post at http://blogs.msdn.com/excel/archive/2010/04/07/add-a-table-of-contents-to-your-workbook.aspx
Posted
Apr 07 2010, 04:53 PM
by
Microsoft Excel 2010