I set up a list based off of a calendar, this is a list of tickets we have available to employees, I have set it to not allow an employee to sign up for more than 1 set of tickets, is it possible to "lock" that cell that holds the employee name so that no-one may go in and overwrite that?

1 Answer 1


Out of the box, you can't lock a cell.

You can use JavaScript or do something with a Lookup column linking to another list.

Lookup column linking to another list would require a good amount of work. You'd need to create a list with every employee (keep it updated), apply read only permissions to the list, and grant read / write to admins. The Person and Groups column type cannot be used as a lookup source, so you'd need to use the Title column or a single line of text column type.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.