Protecting Formulas in cells

[Guest]

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

 

[Guest]

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

 

[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
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Guest]

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
toolsrotection protect sheet
and apply a password if you want. Note that the security provided by this is
pretty flimsy.

Mike