| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hyperlink some 10 sheets in a workbook
hi all,
I have 11 sheets in the workbook. in the first sheet i will place all the sheets names of the present workbook.I need to Hyperlink all the sheets from the first sheet Thanks and Regards Anil Hungund |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hyperlink some 10 sheets in a workbook
Sounds like 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.21 ... 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! -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "anil" wrote: hi all, I have 11 sheets in the workbook. in the first sheet i will place all the sheets names of the present workbook.I need to Hyperlink all the sheets from the first sheet Thanks and Regards Anil Hungund |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hyperlink some 10 sheets in a workbook
that is quite an add-on, nice!
another feature you can use is a simple right on the arrows next to your tabs and a list of the tabs appear. no need for hyperlinks. -- Brian "Max" wrote: Sounds like 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.21 ... 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! -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "anil" wrote: hi all, I have 11 sheets in the workbook. in the first sheet i will place all the sheets names of the present workbook.I need to Hyperlink all the sheets from the first sheet Thanks and Regards Anil Hungund |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| auto hyperlink between many sheets? | Excel Discussion (Misc queries) | |||
| How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
| Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
| How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions | |||
Hybrid Mode
