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

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

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