Protecting select cells

[Derrick]

Is there a way to protect a sheet, and its formulas, but only for a few cells
- for the 2003 version?

for example: protected - f3 to f6, f8
unprotected - f2, f7
this way there are a few cells to imput data, and formulas in protected
cells won't be accidentally deleted, causing problems for calculating...

I appreciate the help!

 

[Eduardo]

Hi,
Select the cells you want to unprotect, then right click on the mouse,
format cells, last tab Protection, uncheck locked. then protect your workbook
If this helps please click yes, thanks

 

[Jim Thomlinson]

There are 2 aspects to protecting cell. First is locking the cells and second
is protecting the sheet.

Locking Cells - One aspect of cell formatting is whether it is locked or
not. You can access this property using Format -> Cells... -> Protection tab
and toggle the Locked property. The locked property does nothing until the
sheet is protected. What the locked property does is it specifies if the cell
is allowed to be updated once the sheet is protected. So if a cell is locked
and the sheet is protected then the user can not change the cell. This is how
you want to treat your formulas. If a Cell is not locked and the sheet is
protected the the user can change the cell. This is your input section.

Protecting a Sheet activates the locks that you have in place. If a cell is
not locked then protection does nothing to that cell. If ithe cell is locked
then once protected the cell can not be updated.