Relative Content

Tag Archive for validationloggingeventslockingprotected

Protecting worksheet cells after data entry

I have been trying different approaches to protect a worksheet from being changed after data entry. The behavior I am trying to achieve is to allow users to make entries into a cell but then lock that cell from being edited after data entry. The simplest code I’ve come accross is the following