Thanks for the feedback.

Beats the heck out of having a dropdown on every sheet<g


Gord

On Wed, 18 Mar 2009 17:06:11 -0500, "Bassman62"
wrote:

Thank you kindly.
Sometimes I can certainly complicate the situation.
Regards

"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Might be easier to look at these alternatives.

Right-click on one of the sheet navigation arrows to get a 15 sheet
listing
and "more".

Another option................................

You can build a Navigation Toolbar as per Dave's code on Debra
Dalgleish's
site. Sorts as well as navigates.

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

Or see this google search thread for the BrowseSheets macro from Bob
Phillips.

http://tinyurl.com/yoa3dw

Personally, I prefer Bob's method.


Gord Dibben MS Excel MVP

On Wed, 18 Mar 2009 16:38:11 -0500, "Bassman62"
wrote:

In xl2007

I have a workbook with many worksheets. I'd like to have, on each sheet, a
dropdown list of hyperlinks to all of the sheets in the workbook.

I'd like our users to be able to click on the dropdown arrow, select a
sheet
from the list and go to that sheet. (even a predetermined cell on the
selected sheet if possible)

Because of the number of sheets involved I think a dropdown with scroll
bar
would be much more user-friendly than the tab list along the bottom.

Thanks to Tim Zych I have a list of sheet names on a "Master" sheet that
might be used as a source.

I envision something that looks like the Data Validation List dropdown but
has the hyperlink capability.

Any assistance with this will be greatly appreciated.