Inserting and Removing Hyperlink within active Workbook

**Bhummel** · 09-16-2012, 11:50 PM

Hello! I am a beginner when it comes to Excel but I am trying to self teach myself.

Here's the situation. I have a drop down list with several options. If they select any of the options I have an IF statement to put text in a corresponding cell and "" so if blank is choosen or a different option is selected is it essential void/null. Now with each of the options in the drop down list I would like to have a hyperlink generated in a following cell. I know how to use hyperlinks just fine, it's just that I want different hyperlinks to show in same cell with the different options. I also want no hyperling to show if the blank is picked in the drop down list.

i.e. (this is not how mine is set up, but it'll get the point across)

A1 // You click on 3
A2 // IF statement with conditional formatting will display "How Many?"
A3 // (Now i want hyperlink to appear so that the user can click to jump to page 10 of workbook

Conditions: If user selects blank in A1 I want hyperlink to disappear.

(Right now I am using two conditional formating statements to overwrite in white text!!! Which we all know is no good because the link is still active.)

Thank you for your help!

**JBeaucaire** · 09-17-2012, 01:35 AM

You can use the HYPERLINK() formula in A3 to create a hyperlink to jump to another sheet. You need to explain the logic of how the answers in A1:A2 result in a jump to sheet10. Or is that sheet named something else?

On my code site, I've got a lot of example Hyperlink() formulas for things like this, since you're trying to teach yourself perhaps you can adapt one of these yourself.

Start here: 3D Hyperlinks

**Bhummel** · 09-17-2012, 04:26 AM

Here is the same row, but copy and pasted three times for a better explanation.

I do not want the hyperlink(s) to be visible at all times, only when a "Yes" condition exists.
If a "No" condition exists I have IF statetments and Conditional formatting to make the rest of the row blank and normal formatting.

Thanks for the response, maybe this makes more sense now.