How to lock cells based on another

[cdulong]

Hello,

I am looking for a method (probably a macro of some sort) that will lock a range of cells (c24:f24) if another cell(B30) has a value of ""(empty), I have looked around and found some code to perform this but I can't figure out exactly were to put it and how to properly make it run.

Just as some extra information the sheet that this is currently needed in is protected with a password. So I would like to work this into the logic if possible to ensure the sheet is protect with such password after the lock or unlock has been performed.

Thanks,
cdulong

 

[SkipVought]

hi,

found some code to perform this but I can't figure out exactly were to put it and how to properly make it run.

Please post your question and the code you have in Forum707.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[cdulong]

Thanks!!!

Done.