Home |
Search |
Today's Posts |
#1
|
|||
|
|||
hyperlinks in a dropw down list
Is there a way to have a drop down list which contains file names that are
also hyperlinked? I have a master spreadsheet with links to other files, but some of these files are located in folders with other files. I would like to be able to choose from a drop down list and automatically link out to the chosen file. Wazooli |
#2
|
|||
|
|||
I don't think directly.
But maybe you could have a macro that would open the file that was selected. But that depends on what the dropdown list is... Data|Validation Combobox from the Control Toolbox Toolbar DropDown from the Forms toolbar (and maybe what version of excel you're using) Wazooli wrote: Is there a way to have a drop down list which contains file names that are also hyperlinked? I have a master spreadsheet with links to other files, but some of these files are located in folders with other files. I would like to be able to choose from a drop down list and automatically link out to the chosen file. Wazooli -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a dynamic list | Excel Worksheet Functions | |||
List box not being displayed in second worksheet | Excel Discussion (Misc queries) | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
Creating a list from an existing list. | Excel Worksheet Functions |