Unlock Data Validation Cells Only If Prior Cell Selection Made

[mjo1983]

I have 3 Data Validation Cells (C1:C3). I am trying to lock the data validation tab on C3, until a selection is made in C2.

Is there a way to do this using VBA code?

Any help would be appreciated

[Mumps1]

Start by unlocking cells C1 and C2. Leave cell C3 locked. Next protect your worksheet. Copy and paste this macro into the worksheet code module. Do the following: right click the tab for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. You will be able to make a selection only in C1 and C2. Once you make a selection in C2, cell C3 will become unlocked.

Please Login or Register  to view this content.

[mjo1983]

Start by unlocking cells C1 and C2. Leave cell C3 locked. Next protect your worksheet. Copy and paste this macro into the worksheet code module. Do the following: right click the tab for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. You will be able to make a selection only in C1 and C2. Once you make a selection in C2, cell C3 will become unlocked.

Please Login or Register  to view this content.

Awesome, this code works great by itself. Thanks for the quick reply! I now have a new problem though. Perhaps you might be able to assist. I have existing VBA code in the same section, and I'm not sure how to place the new code in order to get all of it to work.

My initial code is:

Please Login or Register  to view this content.

How might I integrate both codes so they work together?

[Mumps1]

I'm not sure if this will do what you want. It would be easier to help if you could post a copy of your file with a detailed explanation of what you want to do.

Please Login or Register  to view this content.