| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink disappear
I have a spreadsheet in which there is an 'if' clause. By answering with a
"yes" a suggestion displays further down the spreadsheet - and that suggestion has an associated hyperlink. My problem is that if you were to answer "no," the suggestion disappears (which I want) but the hyperlink remains associated to those cells. Is is possible to remove the hyperlink along with the association? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hyperlink disappear
Maybe you could just link to the cell that contains the hyperlink???
I put this in A3: =HYPERLINK(IF(A1="yes","#"&CELL("address",B88), "#"&CELL("address",A3)),"clickme") kdoggity wrote: I have a spreadsheet in which there is an 'if' clause. By answering with a "yes" a suggestion displays further down the spreadsheet - and that suggestion has an associated hyperlink. My problem is that if you were to answer "no," the suggestion disappears (which I want) but the hyperlink remains associated to those cells. Is is possible to remove the hyperlink along with the association? Thanks! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I emulate rightclick on a hyperlink in an Excel Macro | Excel Discussion (Misc queries) | |||
| Hyperlink problem to cell in same workbook | Excel Worksheet Functions | |||
| Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
| Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) | |||
| Removing hyperlink | Excel Discussion (Misc queries) | |||
Linear Mode
