Activate / deactivate a link based on the value of a cell

M

Michael Lanier

Cells A1 and B1 are merged and together comprise a dropdown list of
items in Sheet1. When the item selected in A1 is equal to an item
already posted in C1, I want to automatically generate a link to send
the user from Sheet1!A1 to the blank cell Sheet2!D1. The link must be
generated upon the selection of the item from the dropdown list. Once
an entry is placed in Sheet2!D1, I want the link in Sheet1!A1 to be
deactivated. It will be acceptible if this executes upon the user's
return to Sheet1. Is this possible? Thanks for any help you can give.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to open a designated sheet in a separate file 2
To link sheet1 cell to sheet2 three rows merged cell 6
Set value of a cell with a dropdown list during run time (C#) 10
Extracting a Part of a Formula as Text 5
How Do I Change Two Pivot Table Page Selections with VBA Code 1
Word VBA - Automatic change content of a cell in table using dropdown list 5
Changing Cell Color based upon value on another worksheet 2
Refering to a particular cell in a Named Range 3

Top