How do I freeze data in the spreadsheet so no one can change it?

G

gbbmech13

I have store daily sales in a spreadsheet then another sheet that breaks the
daily sales into monthly catagories. Once the month is over, I want to keep
this data frozen. So if I accidently put todays data in the wrong month I
want excell to tell me, "sorry stupid, you already froze this data and can't
change it!" Is this possible?
 
V

Vergel Adriano

gbbmech13,

Try this:

1. Select all cells in the worksheet (CTRL-A)
2. Format->Cells, in the Protection Tab, UNCHECK the "Locked" checkbox.
Click OK
3. Tools->Protection->Protect Sheet. Supply a password if you like, but
make sure you don't forget the password.

Now, at the end of the month, select the cells that you want "frozen".
Then, Format->Cells, in the Protection Tab, CHECK the "Locked" checkbox.
 
V

Vergel Adriano

I forgot, you need to unprotect the sheet first before you can lock/unlcok
the cells. So, at the end of the month, Un protect the sheet, select the
cells that you want "frozen" and lock them. Then protect the sheet again.
 
Top