View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bassman62 Bassman62 is offline
external usenet poster
 
Posts: 117
Default Dropdown list of hyperlinks

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.