Lock Unlock Cells based on Drop down selection by formula or VBA

[Sukhdev Singh]

Dear All,
I am enclosing a sample sheet here with. in which I Need the Cells C3:D8 should be Locked if Value is Selected No in C1 from Drop Down and Cell C3:D8 Should be Unlocked if Value is selected as Yes in C1 from drop down. Kindly help.
Thanks,
Best Regards,
Sukhdev Singh

 

[Somendra Misra]

Hi Sukhdev,

By Locked , you means to say non-editable?

If so than it can be only achieved if the sheet is protected with or without password.

Do the other range will be required data entry or not?

Regards,

 

[Sukhdev Singh]

Hi Sukhdev,

By Locked , you means to say non-editable?

If so than it can be only achieved if the sheet is protected with or without password.

Do the other range will be required data entry or not?

Regards,

Hi Somendra,
Thanks for reply. I Mean to say if I select the value No, CELLS (C3:C8) should be Non Editable and if Value Selected Yes, CELLS (C3:C8) should be editable. Rest of the sheet can be editable.
Thanks,
SUkhdev Singh

 

[Somendra Misra]

@Sukhdev Singh

See this file.

Regards,

 

[Sukhdev Singh]

@Sukhdev Singh

See this file.

Regards,

Hi Somendra,
Thanks for resolving my Problem. It is working perfectly.
Thanks,
Best Regards,
Sukhdev Singh

 

[Somendra Misra]

You are Welcome!!!

Regards,

 

[Sukhdev Singh]

Hi Somendra,
Thanks once again for resolving my query, but I have tried same in actual sheet in which I wished to implement it, but it is protecting all desired cell on selection of Yes and No Both. Kindly guide how can I resolve it. Attaching the original sheet for your kind perusal. I need D20:G23 unlock if value D19 contains Yes and D20:D23 lock if value in D19 contains No. What mistake i am doing here. please guide.
thanks,
Best Regards,
Sukhdev Singh

 

[Sukhdev Singh]

Hi Somendra,
Thanks once again for resolving my query, but I have tried same in actual sheet in which I wished to implement it, but it is protecting all desired cell on selection of Yes and No Both. Kindly guide how can I resolve it. Attaching the original sheet for your kind perusal. I need D20:G23 unlock if value D19 contains Yes and D20:D23 lock if value in D19 contains No. What mistake i am doing here. please guide.
thanks,
Best Regards,
Sukhdev Singh

Dear Somendra,
I found the error where I was doing mistake. DOne. Please leave it thanks
Best Regards,
Sukhdev singh

 

[Somendra Misra]

@Sukhdev Singh

See the file. and notice the changes made on code, Cell Protection property. If you don't understand it than write back.

Regards,

 

[prasanna1985]

Hi ,

i need help here, since i am beginner in excel.

how to lock the cells of row, based on the answers that we select.

eg: if my ans is "closed", then rest of the cells on that row till few range should be blocked.

if the ans is other than closed, rest of the cells can be able to edit.

pls suggest. i have attached the file.