Lock Cells

[Trevor2002]

Hi
I would like to know if there is a way to lock cells after an entry is made in the cells. Example: I would like to have different people enter data in cells B1 thru B12. After data was entered into any of these cell no one could change any of the data except myself.
Thanks trevor2002

 

[Tazguy37]

Sure. You could unlock all the cells (select all cells, Format, Cells, go to the Protection tab, and uncheck 'Locked'). Select the cells you wish to lock, go to Format, Cells, Protection tab, and check 'Locked'. Then go to Tools, Protection, Protect Sheet, enter a password if you wish, and select OK.

Hope that helps!