Automatically create hyperlinks

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.

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.

aposatsk wrote:
>
> 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.
>
> --
> aposatsk
> ------------------------------------------------------------------------
> aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709
> View this thread: http://www.excelforum.com/showthread...hreadid=564431

--

Dave Peterson