Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dropdown list of hyperlinks
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dropdown list of hyperlinks
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dropdown list of hyperlinks
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |