hyperlink some 10 sheets in a workbook

  • Thread starter Thread starter anil
  • Start date Start date
A

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
 
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!
 
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.
 
Back
Top