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

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