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

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

"James8309" <(E-Mail Removed)> wrote in message
news:ca226bc3-6251-46b8-a70f-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
> news:ca226bc3-6251-46b8-a70f-(E-Mail Removed)...
> > 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
>
>
>