Conditional Cell Lock
 

Hi everyone,

I am just having problems with people editing the cell values. I know
how to lock particular cells in a worksheet but how do I achieve
conditional cell lock?

i.e People put inputs in column A and normally Column G:H are locked
for editing. However if input in column A is "ABC" I want to let them
edit or put inputs in Column G:H for that row.

e.g. If A10 = "ABC" then Unlock G10 & H10 and if cell value is other
than "ABC" then lock.

Thank you for your help in advance.


Regards,

James

Conditional Cell Lock
 

Please don't crosspost. I just tried to answer your question in group
excel.worksheet.functions.
JM

"James8309" wrote in message
...
Hi everyone,

I am just having problems with people editing the cell values. I know
how to lock particular cells in a worksheet but how do I achieve
conditional cell lock?

i.e People put inputs in column A and normally Column G:H are locked
for editing. However if input in column A is "ABC" I want to let them
edit or put inputs in Column G:H for that row.

e.g. If A10 = "ABC" then Unlock G10 & H10 and if cell value is other
than "ABC" then lock.

Thank you for your help in advance.


Regards,

James

Conditional Cell Lock
 

Hello, I've been trying to look for this exact situation but the opposite. I
would like to lock cell B1 if "abc" is entered in cell B35. Also, is there a
way that when cell B1 locks a specific note pops up for that cell?

Thanks!

"Joerg Mochikun" wrote:

Please don't crosspost. I just tried to answer your question in group
excel.worksheet.functions.
JM

"James8309" wrote in message
...
Hi everyone,

I am just having problems with people editing the cell values. I know
how to lock particular cells in a worksheet but how do I achieve
conditional cell lock?

i.e People put inputs in column A and normally Column G:H are locked
for editing. However if input in column A is "ABC" I want to let them
edit or put inputs in Column G:H for that row.

e.g. If A10 = "ABC" then Unlock G10 & H10 and if cell value is other
than "ABC" then lock.

Thank you for your help in advance.


Regards,

James