Protecting Formulas in cells

  • Thread starter Protecting Formulas from deletion
  • Start date
P

Protecting Formulas from deletion

I have a fairly basic spreadsheet that my on the road sales staff fill in
weekly. It has formulas to calculate Gross Profit. However they sometimes put
in incorrect information and then clear out those cells and as they do so the
formauls go.

Is there someway of not letting them edit the cells that contain the formulas?

Cheers
Mark
 
M

Mike H

Protecting Formulas from deletion said:
I have a fairly basic spreadsheet that my on the road sales staff fill in
weekly. It has formulas to calculate Gross Profit. However they sometimes put
in incorrect information and then clear out those cells and as they do so the
formauls go.

Is there someway of not letting them edit the cells that contain the formulas?

Cheers
Mark
Click to expand...
 
B

Bob Phillips

Select all cells and unlock them (Format>Cells>Protection)

Then select the formula cells and lock them (same route)

Then protect the sheet (Tools>Protection)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Protecting Formulas from deletion" <Protecting Formulas from
[email protected]> wrote in message
news:[email protected]...
 
M

Mike H

Select all editable cells and then:-

Format|cells|protection and remove the locked checkmark.

It's a good idea to colour these cells or apply a border to allow users to
easily find them.

Now protect the sheet using
tools:protection protect sheet
and apply a password if you want. Note that the security provided by this is
pretty flimsy.

Mike
 
Top