software

I have a spreadsheet in which there is an 'if' clause. By answering with a
quot;yesquot; a suggestion displays further down the spreadsheet - and that
suggestion has an associated hyperlink. My problem is that if you were to
answer quot;no,quot; 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!

Maybe you could just link to the cell that contains the hyperlink???

I put this in A3:

=HYPERLINK(IF(A1=quot;yesquot;,quot;#quot;amp;CELL(quot;addressquot;,B88),
quot;#quot;amp;CELL(quot;addressquot;,A3)),quot;clickmequot;)kdoggity wrote:
gt;
gt; I have a spreadsheet in which there is an 'if' clause. By answering with a
gt; quot;yesquot; a suggestion displays further down the spreadsheet - and that
gt; suggestion has an associated hyperlink. My problem is that if you were to
gt; answer quot;no,quot; the suggestion disappears (which I want) but the hyperlink
gt; remains associated to those cells. Is is possible to remove the hyperlink
gt; along with the association? Thanks!

--

Dave Peterson