| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Lists and Hyper links
How can I get Excel to display a dropdown list of Hyperlinks? I tried the
Validate command but did not get very far. Thank you in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 Lists and Hyper links
You probably have already found that referencing a list of hyperlinks in a
data validation drop-down produces only "cold" hyperlinks (not clickable). However, say we put the dropdown in B1; in A1 enter: =HYPERLINK(B1) This will produce a nice, "hot", link in A1 -- Gary''s Student - gsnu200751 "PETER J" wrote: How can I get Excel to display a dropdown list of Hyperlinks? I tried the Validate command but did not get very far. Thank you in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Hyper links for the whole sheet | Excel Discussion (Misc queries) | |||
| hyper links stop working | Excel Worksheet Functions | |||
| hyper links in pull down menus | Excel Discussion (Misc queries) | |||
| hyper links not working in Excel workbook | Excel Discussion (Misc queries) | |||
| Hyper Links | Excel Worksheet Functions | |||
Hybrid Mode
