Install FormulaLock
About one minute, once per spreadsheet.
- Open your Google Sheet. Go to Extensions > Apps Script.
- Delete anything in the editor, then paste the full code from formulalock.com/FormulaLock.gs (open it, Ctrl+A, Ctrl+C).
- Rename the project from "Untitled project" to FormulaLock (click the name at the top), then click the save icon. Close the Apps Script tab and reload your sheet.
- A FormulaLock menu appears. Pick Lock selected cells. Google asks you to authorise the script the first time: click OK / Review permissions, choose your account, then on "Google hasn't verified this app" click Advanced > Go to FormulaLock (unsafe) > Allow. Google shows "unverified" for every script you paste yourself that hasn't been through their app review; you can read every line of the code first.
Pro key
After buying, use FormulaLock > Enter Pro licence key in each spreadsheet where you want unlimited tabs.
Uninstall
Unlock your cells (FormulaLock > Unlock selected cells), then delete the code in Extensions > Apps Script.