protect contents of cell after checking checkbox

Originally Posted by carlossaltz

I have a spreadsheet with many records. The spreadsheet is protected, but all empty lines (records) are unprotected. All verified records are protected to prevent changes. I would like to add a checkbox to each record that would activate a macro to protect the contents of each record after checking it. After adding data to a new line, I would check the checkbox, which would change to protection setting of each cell in the record to protected. This would prevent changes to the information in each record, but would allow users of the worksheet to enter new information in unprotected cells. Since the worksheet is protected, and only authorized users would know the password, changes to information would be controlled.

I thought code in VBA could be written to accomplish this, but I am not familiar enough with VBA to do this.

Hi,
Try this code,

Please Login or Register  to view this content.