Locking cells depending on what is entered in another cell

**nujwaan** · 09-22-2009, 04:15 AM

Hi,

I'd like to lock some cells depending on what is put in a particular cell.

As shown by the file attached, if the first column (Amendments) has a "no" in A4, I'd like to lock out cells B4:D4. (The sheet will be protected). If it's a "yes" then the cells are unlocked.

I'd like to then apply this to all subsequent rows (i.e. lock B5:D5 if a "no" in A5 etc.)

Can anyone help?

Have attached a sample file.

Nujwaan

**Palmetto** · 09-22-2009, 07:35 AM

Place this code in the module of the worksheet and adust range reference as needed.

Please Login or Register  to view this content.

**DonkeyOte** · 09-22-2009, 08:03 AM

Below is a slight variation which will make use of a Password constant and unprotect/protect the sheet object itself as part of this routine (else locking the cells has no effect):

Please Login or Register  to view this content.

**nujwaan** · 09-23-2009, 08:20 AM

Hey Donkeyote thanks for that.

The thing is how do i make it so the cell is ONLY unlocked when the column before says Approved rather than the 'IS Nothing...' bit you've written?

Regards,
Nujwaan