> * Lock sheets, even without a password. 90% of the time will prevent people from breaking the spreadsheet in the first case.
Is there any way to lock all cells in sheet except for certain input cells? That seems like it would prevent many errors.
Is there any way to lock all cells in sheet except for certain input cells? That seems like it would prevent many errors.
Example: a lookup list for “hardware models” which is protected. So you can’t add a new model, but some cretin forces you to keep using the sheet.
With great power comes great responsibility.
When you Protect a spreadsheet, all Locked Cells become... locked.
So a typical use case is to only un-lock the cells you wish people to enter variables into, (color the cell to make it clear), and then protect the sheet so nothing else can be tampered with.