Yes, but there are other ways to select a sheet to go to.

Right-click on the navigation arrows at bottom left to get a list of 15 sheets
and "more sheets".

Rather than an dropdown list sheet with hyperlinks, try a sheet navigation
toolbar or similar.

Sheet navigation bar from by Dave Peterson at Debra Dalgleish's site.

http://www.contextures.on.ca/xlToolbar01.html

Or Bob Phillips' Browsesheets macro.

See this google search result.

http://tinyurl.com/yoa3dw


Gord Dibben MS Excel MVP

On Mon, 3 Mar 2008 17:22:06 -0800, Destiney
wrote:

Is there a way when using a data validation list, to hyperlink the list
options to pages in the workbook? So for example, if you had a lot of
worksheets in one workbook, is there a way to choose a worksheet from the
list and have it go to the corresponding worksheet?


Thank you.