How do I create a first page index of worksheets in my workbook?
Perhaps the easiest way is to create Hyperlinks to cell A1 of each sheet.
From the Excel main menu:
<insert<hyperlink
Click the [Place in this document] button
Select the sheet (in the Cell Reference structure)
Change the text to display.
Click [OK]
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
"Sam" wrote:
Hi!
I've a workbook with over 40 worksheets, and would like to create a
list(index) on the first worksheet, so that (a) any user can see all the
worksheets in the workbook, and (b) perhaps if I click on the worksheet name,
I can go to that worksheet?
|