Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
That worked! Thank you
Lock a set of Cells using a Check Box
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I have searched the form and can't find anything on what I'm trying to accomplish. I need to lock a specific set of cells when a checkbox is clicked. I understand how to do it if it's always the same cells. What I need is a little different. There is a checkbox for each line. anytime one of the checkboxes is checked, I want it to lock just the cells in that row.
In my example. when the checkbox is selected in G2, I want it to lock the just the cells of A2:F2. When the checkbox is selected on G4, I need it to lock the cells of A4:F4. Does this make sense? I don't have any code as I'm not sure where to even start. Thanks in advance for the help
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
8 answers
Sort by: Most helpful
-
Deleted
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
-
Anonymous
2020-07-31T15:04:49+00:00 -
Deleted
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
-
Anonymous
2020-07-30T19:52:41+00:00 Currently, they are Form Control, but I can do either. I'm not set on either one. I am using conditional formatting to also Color the row. but I can do those other ways.
-
HansV 460.5K Reputation points MVP Volunteer Moderator2020-07-30T19:43:22+00:00 What kind of check boxes are those? Forms check boxes or ActiveX check boxes?