View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 698
Default 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?