MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Spreadsheets

Posted by Randycas on June 22, 2001 7:26 AM

I have a series of worksheets in a workbook and I want to have them listed like you would have a table of contents where i would list like

Policy Information - and when i click on that i would see all the worksheets associated with the topic displayed and the user would select which worksheet they need. The Microsoft Excel 2000 Sample is the kind of set up i want to achieve. Does any one know how to do this.

Thanks in advance

Posted by IML on June 22, 2001 11:09 AM

Have a look at

when you install this add in, look under sheets, create clickable index page.

good luck.

Posted by Randyas on June 25, 2001 4:33 AM

Thanks for you help, I used the add in and it going great so far.