hyperlink some 10 sheets in a workbook

[anil]

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

 

[Max]

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/primitivesoftware/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!

 

[Brian]

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.