| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hyperlinked drop-down entries
My situation... I want to create a drop down list wherin the entries are
hyperlinked to their respective worksheets. ex: WS=worksheet WS "Regional Directory" contains a cell where I want to create a drop-down list. "Deep South" specifically. I have created a list of all states that reside in this region. WS "Drop Down Lists". on this ws I hyperlinked the individual states to their named worksheets. ie. "Alabama" hyperlinked to "WS Alabama". Named this list "DeepSouth" When I create the drop down on WS Regional Directory, using source "=DeepSouth" It creates a non hyperlinked list which in text matches the sourced list. However, the list entries within drop-down menu are not hyperlinked. Which is what I need them to be. Suggestions?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How many entries can be put into a drop down list in excel? | Excel Worksheet Functions | |||
| Avoiding Duplicate entries - from a drop down | Excel Worksheet Functions | |||
| multiple item entries from drop-down list | Excel Discussion (Misc queries) | |||
| How to extend the no' of displayed entries in a drop down list | Excel Discussion (Misc queries) | |||
| Drop 3 Lowest Entries | Excel Worksheet Functions | |||
Threaded Mode
