In Excel 2003, to protect data entered in cells, and allow only editing empty cells, I do the following:
In an empty worksheet, I select all cells, and Format | cells | protection | uncheck locked property.
After I enter data in some cells, I select these cells and check the locked property.
To protect the entered data from being edited, I protect the sheet by
Tools | Protection | Protect Sheet | Allow users to Select locked cells and Select unlocked cells
Now only the empty cells could be edited.
My question is that:
Is it possible to automate the process of letting the cells to be unlocked when they are empty, and to be locked when they contain data? So that I do not have to select the cells containing data and lock them manually each time I enter data in them.