Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlinks in pull downs . . .
I have a list, used as a pull down. But some of the list entries contain
hyper links. For example, the "list" is made up of standard comments used often in a lay out report. The comments could be . . . OK at MMC: See Profile Section . . . This comment should be a link to the Profile section on the workbook. (BTW: It works fine in the actual list I made. Just not after selected from a pull down.) Also, all of the entries in the list are not hyper links. About half are. I made the list with some of the entries being hyper links to other tabs (sheets) So a customer can go right to the relevant sheet from the comments column. So the list works fine. The links work fine. I make them into a pulldown, select the range for the list, etc., and the pull down works fine. But when I select an entry from the list, the link becomes text. For my range of cells I'm using, for example . . . =$M$10:$M$42 Can the entries be formatted (or range defined) so the hyper links still work after being selected from the pull down? Thanks. :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relative Hyperlinks to local files | Links and Linking in Excel | |||
hyperlinks in different drives | Excel Discussion (Misc queries) | |||
How do I set up a cell with a pull down list? | Excel Discussion (Misc queries) | |||
Why does AutoFilter not show all the data in the pull down? | Excel Discussion (Misc queries) | |||
Hyperlinks to pull up PDF files | Excel Discussion (Misc queries) |