@Stefan_Pastia
Protect formulas or cells without leaf protection from alteration
In some situations, the use of the Sheet protection can be undesirable. In order to protect cells with formulas or any other cells from unwanted changes in these cases, the following procedure can be used.
- Use the Format cells / Protection command to define which cells should be provided with cell protection and which should not. To remove the cell protection, simply remove the tick from Locked.
- Select the desired cell range or all cells in the worksheet.
- Now open the corresponding dialog window via the menu Data / Data tools / Data check / Data check.
- Under Allow, select the Custom entry and enter the following formula: =NOT(CELL("protect",A1))
- With a click on the OK button, the defined cells are now protected as required.
Important:
The procedure presented protects the cells from accidentally overwriting the cells. However, the locked cell can still be deleted with the delete key. Protected cells can also be overwritten using the copy and paste function. The function presented is therefore not a particularly good protection, but is sufficient in practice in many cases. If you want to have absolutely secure protection you cannot avoid a password.
Finally, it is also possible to lock only one cell securely with a password on a worksheet.
Lock or unlock specific areas of a protected worksheet
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
