Forum Discussion
Serial Locking
In some situations, and why not with array functions, the use of the blade guard may 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 when 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 verification / Data verification.
Under Allow, select the Custom entry 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 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.
Additional Info:
VBA Excel - How to lock specific cells but allow filtering and sorting
https://stackoverrun.com/de/q/2689186
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.