Dropdown list of hyperlinks

  • Thread starter Thread starter Bassman62
  • Start date Start date
B

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.
 
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
 
Thanks for the feedback.

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


Gord
 
Back
Top