cliffton jhed saldavia
asked on
(Operation & Maintenance)Need to lock the row cells after the cell is click to "Closed"
Good day Guys.For some of you who knows how to lock the rows of the cell,I'll be needing your help!!!
I want to lock only the formatted cells in a row (not the entire row).There's a "Pending" and "Closed" dropdown list.I want to lock the specific data in a row after I click the "Closed"
Please see the attached file below.
I'll be happy and really appreciate for your suggestions/help.
I want to lock only the formatted cells in a row (not the entire row).There's a "Pending" and "Closed" dropdown list.I want to lock the specific data in a row after I click the "Closed"
Please see the attached file below.
I'll be happy and really appreciate for your suggestions/help.
ASKER
so it means the whole sheet will be lock?Is there anyways that I can lock an entire row only?I will upload the file Sir.
ASKER
WO-FORM2.xlsm I need sam examples for Sir Cox
It doesn't mean the whole sheet will lock, only specified cells.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you Sir gonna check this one.Ill get back to you.
ASKER
Wow!This is wonderful Sir Cox.Thank you Sir for this.I am really thankful for this one Sir.Your awesome
If you need further help let me know.
cliffton jhed saldavia should have awarded points, not sent a close request
You can also use a method of Data Validation.
By setting a validation rule that is enforced when another condition is met ie relevant cell value is "Closed" but the validation is impossible, eg cell value >1 AND < 1, the contents of that cell then can't be changed because the validation won't let it change.
By setting a validation rule that is enforced when another condition is met ie relevant cell value is "Closed" but the validation is impossible, eg cell value >1 AND < 1, the contents of that cell then can't be changed because the validation won't let it change.
ASKER
Mr Cox already provided the best solution.I'm so thankful for this one.
You've accepted your own post, not mine.
ASKER
Thank you for the tips Sir.I'll remember this one.
You cannot lock cells without protecting the sheet as well.