Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
dropdown list determined by another dropdown list | Excel Discussion (Misc queries) | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
Dropdown Hyperlinks | Excel Programming | |||
how to create multiple hyperlinks within a dropdown list | Excel Discussion (Misc queries) |