Lock all the formula cell

Hi Vignesh.

There could be two approaches to this.

1st) Lock all existing formulas. Now after entering a formula / constant into a cell, a change event macro will trigger and will check if entered cell has formula and if yes, lock the cell and protect the sheet.

2nd) Upon entering a formula / constant into a cell, a change event macro will trigger and will check if any of the cell in entire sheet has formula and if yes, lock those cells and the protect the sheet.

which way you want to go ?

Regards,
DILIPandey

<click on below 'star' if this helps>