Protecting Cells

  • Thread starter Thread starter Scott Nash
  • Start date Start date
S

Scott Nash

Hello,

I need to be able to protect a range of cells on a worksheet. These cells
have formulas in them, which will return a value based on what is entered in
a particular cell. For example, if I enter the number 2 in cell A1, then A2
automatically displays "NEEDS ASSISTANCE"

Whats been happening is, users have been clearing the contents of the sheet
and erasing the formulas! My question is, what is the best way to protect
the formulas, so the workbook still allow the functions to return values
into the cells, but doesn't allow a user to change the formula?

Hope that wasn't too confusing. Thanks all!
 
Select the entire sheet, click on Format --> Cells... [Protection] tab.

Check the "Locked" box (make sure the check mark is black, not gray)
Click "Ok"

Now select the cell or cells that you want the users to be able to change.

Format --> Cells... [Protection]

Uncheck the "Locked" box. Last, but not least, click on Tools -->
Protection --> Protect Sheet...
 
For the cells you need for data input - Click on Format|Cells, select the
Protection tab, untick the locked option to unlock these cells. Then click
on Tools| Protection| Protect Sheet, use a password for what it is worth, and
you can even untick the option to select locked cells, so that users can only
select cells they are supposed to enter data in.
 
Back
Top