Dropdown list of hyperlinks

[Bassman62]

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.

 

[Gord Dibben]

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

 

[Bassman62]

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

 

[Gord Dibben]

Thanks for the feedback.

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


Gord