Hi Folks,

Has anyone out there ever tried to lock a range of cells based on a condition. For example if there is a cell which is locked to everyone but the select few, it it possible that on entering data into that cell another range of cells can be locked down to prevent reprospective data changes.

Any help would be gratefully received.

"Bear3164" wrote:


Hi Folks,

Has anyone out there ever tried to lock a range of cells based on a
condition. For example if there is a cell which is locked to everyone
but the select few, it it possible that on entering data into that cell
another range of cells can be locked down to prevent reprospective data
changes.
Looking for same. Need to lock cell B1 if there is data in A1 and vice
versa, lock A1 if B1 contains data.

Good news. I found partial solution.
here is a link to VBA code which locks columns based on conditonal value
http://www.mrexcel.com/archive/VBA/16225.html