creating directory for workbook
 

Hello.

I would like to create a directory worksheet for a my workbook the contains
40 or so worksheets. So for example the first worksheet in the workbook
contains a list with the titles of all the other worksheets with in this
workbook. One would be able to click on the title on the list and it would
take you to the respective worksheet.

Please advise if and how this is possible.

renee

creating directory for workbook
 

Renee, so you're looking to build a table of contents?

One good way is Jim Cone's fine, free product (his XL Extras add-in) at his:
http://www.realezsites.com/bus/primi...e/products.php

Scroll right down to the bottom of the page for the download link:
XL Extras - release 1.19 ... Download
A collection of additional features including...
**create table of contents with hyperlinks to each sheet

Jim's add-in will do exactly what you're looking for (and much more ..)

After installing, just click Insert Table of Contents (new menu item),
then sit back and watch Jim's magic go to work <g !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"renee" wrote:
Hello.

I would like to create a directory worksheet for a my workbook the contains
40 or so worksheets. So for example the first worksheet in the workbook
contains a list with the titles of all the other worksheets with in this
workbook. One would be able to click on the title on the list and it would
take you to the respective worksheet.

Please advise if and how this is possible.

renee

creating directory for workbook
 

Use =hyperlink() formula
or use "Hyperlink" in "Insert" menu.

*** Please do rate ***

"renee" wrote:

Hello.

I would like to create a directory worksheet for a my workbook the contains
40 or so worksheets. So for example the first worksheet in the workbook
contains a list with the titles of all the other worksheets with in this
workbook. One would be able to click on the title on the list and it would
take you to the respective worksheet.

Please advise if and how this is possible.

renee

creating directory for workbook
 

See http://tinyurl.com/ps5sl

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"renee" wrote in message
...
Hello.

I would like to create a directory worksheet for a my workbook the
contains
40 or so worksheets. So for example the first worksheet in the workbook
contains a list with the titles of all the other worksheets with in this
workbook. One would be able to click on the title on the list and it
would
take you to the respective worksheet.

Please advise if and how this is possible.

renee