Unlock / Lock cell based on another cel value

**BernardTodd** · 02-10-2013, 05:49 PM

Hi

I have the following code where if value in J9 = " manual" then cells L9 - W9 are unlocked. How to I get this to work for other rows

Please Login or Register  to view this content.

Administrative Note:

Please see Forum Rule #3 about proper use of code tags and adjust accordingly...
Added for you this time, but please use them in the future…Thanks.

**jeffreybrown** · 02-10-2013, 05:59 PM

How about...

Please Login or Register  to view this content.

**BernardTodd** · 02-10-2013, 06:32 PM

Jeff

Many thanks. all working Ok now.

**Winon** · 02-10-2013, 06:43 PM

Hi BernardTodd,

Welcome to the Forum.

You could also do this without VBA by using data validation.

See the attached WorkBook as sample.

**mubashar** · 03-13-2013, 10:06 AM

Winon ..in ur file the menu is dim ... How to enable it.

**Winon** · 03-13-2013, 10:38 AM

Hello mubashar,

Just Unprotect the Sheet.

Certain Cells have been "Locked" or "UnLocked" and some Cells contain Data validation. Only when the Data Validation criteria in certain Cells is met will it respond accordingly.

Locking or UnLocking Cells only takes effect when a Sheet is protected.

Also see the "Please Consider" note at the bottom of this post.

hope that helps!