4 ms·
> * 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 cel
by dwaltrip 6y ago
> * 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.
- gegtik 6y agoyes. Go to cell properties and you will find there is a "locked cell" property that is on by default. 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.
- nhebb 6y agoI'm reluctant to pimp my own product on HN, but one of the features of Spreadspeed [1] (my Excel add-in) is a Quick Protect tool which protects the sheet but will unlock individual cells based on styling (e.g., Input style). https://www.breezetree.com/excel-utilities https://www.breezetree.com/excel-utilities
- jen729w 6y agoThe problem is that someone creates a sheet, locks all the cells, forces a bunch of people to use it via some process, and then either a) never touches it again or b) leaves the organisation and doesn’t tell anyone the unlock password. 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.