editLock - New Google Sheets Add-on

Google Sheets are incredibly powerful for collaboration and it's great that they can be worked on simultaneously. Sometimes though, you want to add a bit more protection to stop people editing things that they shouldn't.

You can protect cells and ranges from being edited quite easily in Google Sheets, but up until now, that had to be done manually. This was particularly complicated if you had a sign up sheet for example and you didn't want people overwriting or removing people accidentally (or maliciously!).

Once you activate the editLock add-on, as soon as someone edits a cell, it gets locked down and can't be edited by anyone else. See the 2 minute video below for a quick walkthrough.

I hope you find it useful! Get the add-on here.