Automatically create hyperlinks

[aposatsk]

My workbook contains about 50 worksheets. I want to allow the user to
select which worksheet they want to look at from the first worksheet in
the file. However, I really don't want to create 50 seperate hyperlinks
by hand! Is there any way to automate this process?

Furthermore, can I create a drop down menu with the worksheet names
which are hyperlinks?

Thank you.

 

[Dave Peterson]

Maybe you could use David McRitchie's Build Table of Contents to get the list
and the hyperlinks all at
once:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Another option if you want a more generic solution:
http://contextures.com/xlToolbar01.html
From Debra Dalgleish's site.

It builds a toolbar that you can use with any workbook to navigate to any
worksheet.