Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down List with Macro/Hyperlinks
I have a mult-sheet workbook and am trying to make a drop-down menu to
navigate to different sheets. I made a column with names of each sheet and in each cell i put a hyperlink to that sheet. I was hoping that when I made that into a drop-down it would activate the hyperlink, no such luck. Has anyone made something similar that works? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down List with Macro/Hyperlinks
Dave Peterson has instructions here for a worksheet navigation toolbar:
http://www.contextures.com/xlToolbar01.html cncf wrote: I have a mult-sheet workbook and am trying to make a drop-down menu to navigate to different sheets. I made a column with names of each sheet and in each cell i put a hyperlink to that sheet. I was hoping that when I made that into a drop-down it would activate the hyperlink, no such luck. Has anyone made something similar that works? Thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down List with Macro/Hyperlinks
Say in cell A1 we have a Data Validation dropdown that allows the user to
pick from: Sheet1 Sheet2 Sheet3 etc. In B1 enter: =HYPERLINK("#"&A1&"!A1",A1) This makes a nice, "clickable" link in B1 to any sheet in the workbook. -- Gary''s Student - gsnu2007j "cncf" wrote: I have a mult-sheet workbook and am trying to make a drop-down menu to navigate to different sheets. I made a column with names of each sheet and in each cell i put a hyperlink to that sheet. I was hoping that when I made that into a drop-down it would activate the hyperlink, no such luck. Has anyone made something similar that works? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down List with Macro/Hyperlinks
Thanks, that was great. For some reason (maybe because I am using 2007) it
never showed up floating, it was part of the Add-In Ribbon. I was able to move it to the Quick Access Toolbar but it does not float. Still in all very cool thanks! "Debra Dalgleish" wrote: Dave Peterson has instructions here for a worksheet navigation toolbar: http://www.contextures.com/xlToolbar01.html cncf wrote: I have a mult-sheet workbook and am trying to make a drop-down menu to navigate to different sheets. I made a column with names of each sheet and in each cell i put a hyperlink to that sheet. I was hoping that when I made that into a drop-down it would activate the hyperlink, no such luck. Has anyone made something similar that works? Thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down List with Macro/Hyperlinks
Floating toolbars died with xl2007.
If you want to take the time to translate, er, bring the code up to date for xl2007... If you want to learn about modifying the ribbon, you can start at Ron de Bruin's site: http://www.rondebruin.nl/ribbon.htm http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an addin) or http://www.rondebruin.nl/2007addin.htm msnyc07 wrote: Thanks, that was great. For some reason (maybe because I am using 2007) it never showed up floating, it was part of the Add-In Ribbon. I was able to move it to the Quick Access Toolbar but it does not float. Still in all very cool thanks! "Debra Dalgleish" wrote: Dave Peterson has instructions here for a worksheet navigation toolbar: http://www.contextures.com/xlToolbar01.html cncf wrote: I have a mult-sheet workbook and am trying to make a drop-down menu to navigate to different sheets. I made a column with names of each sheet and in each cell i put a hyperlink to that sheet. I was hoping that when I made that into a drop-down it would activate the hyperlink, no such luck. Has anyone made something similar that works? Thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down list with external hyperlinks | Excel Discussion (Misc queries) | |||
Hyperlinks in drop down list | Excel Discussion (Misc queries) | |||
excel drop down list of hyperlinks | Excel Worksheet Functions | |||
Multiple hyperlinks from drop down list | Excel Discussion (Misc queries) | |||
Drop down list with hyperlinks... | Excel Discussion (Misc queries) |