Forum Discussion
Lock formulas but allow movement of cells and deletion of specific columns
Protect formulas or cells without sheet protection from modification
In some situations, the use of blade protection may be undesirable. In order to still protect cells with formulas or any other cells against unwanted changes in these cases, the following procedure can be used.
Use the Format Cells / Protection command to define which cells are to be protected and which are not. To remove cell protection, simply uncheck Locked.
Mark the desired cell range or all cells of the worksheet.
Now open the corresponding dialog box via the Data / Data Tools / Data Validation / Data Validation menu.
Under Allow, select Custom and enter the following formula: =NOT(CELL("Protection",A1))
With a click on the OK button, the defined cells are now protected as desired.
Important:
The procedure presented protects the cells from being accidentally overwritten. 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 does not represent particularly good protection, but it is sufficient in practice in many cases.
I would be happy to know if I could help.
Was the answer useful? Mark them as helpful!
This will help all forum participants.
