Protecting cells in a sheet

R

Ramesh

HI,

There s a sheet in which my staff keeps accounts of the cash received.
Every week, i check the sheet and we tally accounts. Now my requirement is
that she should not be able to modify any cell which i have already checked.
But she should be permitted to enter data in my new cell, like adding new
rows. Some way i can lock the cells after i have checked them.

What s the best way i cud do this in Excel 2k?

Thanks for any tips.

Ramesh
 
O

Otto Moehrbach

Ramesh
Yes, there is a way you can do that. The procedure is as follows:
A cell is protected if it is locked AND the sheet is protected. You must
have both conditions to protect the cell.
You lock/unlock a cell by first selecting the cell or cells, click on
Format - Cells - Protection tab, check/uncheck the "Locked" box.
You protect the sheet by clicking on Tools - Protection - Protect the sheet.
This brings up a box that allows you to choose the specific characteristics
of the sheet that you want to protect. In your case, you want to allow the
user to Select Unlocked cells and Insert Rows, so you would need to check
those boxes and uncheck all the other boxes.
All cells of a sheet are Locked by default. You need to Unlock all the
cells on the sheet to begin with.
To select all the cells of a sheet, click on the small box that is
immediately to the left of the "A" of Column A and immediately above the "1"
of Row 1. Then click on Format - Cells - Protection and uncheck the
"Locked" box.
Now protect the sheet as explained above.
The user can now enter data into any cell.
When you check the entry the user has entered and you want to preclude
changes to that entry, do the following:
Unprotect the sheet.
Select the cells you want to protect.
Lock those cells.
Protect the sheet.
The user can now enter data into any cell except those cells that you have
locked.
HTH Otto
 
R

Ramesh

Wow Otto.. that helps millions!!

Just what i wanted to do for a loong time.

Thanks a million.

Ramesh
 
C

Curious Consultant

I have an additional problem with this in Excel 2003. Let's say rows 2 to
5 contain data that I have put into the "List" format rather than "Range".
This allows the user to add records somewhat as they would in Access. When
you click anwhere in the list a new row is inserted where you can enter data.
Row 8 is a row that totals data in the list and Row 9 is a row that
performs additional calculations on the list. I want these two rows
protected. But when I do that (allowing the insertion of rows), clicking in
the list no longer automatically inserts a new line. Does anyone know of a
work around?
 
Top