Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to raise Directory request box | Excel Worksheet Functions | |||
Creating Links to files in a shared directory | Excel Discussion (Misc queries) | |||
Saving to "open" directory | New Users to Excel | |||
Staying it its own directory. | Excel Worksheet Functions | |||
How do I insert the directory path in my Excel file? | Excel Worksheet Functions |