Protecting Formulas in cells
 

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

Protecting Formulas in cells
 

"Protecting Formulas from deletion" wrote:

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

Protecting Formulas in cells
 

Select all cells and unlock them (FormatCellsProtection)

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

Then protect the sheet (ToolsProtection)

--
HTH

Bob

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

"Protecting Formulas from deletion" <Protecting Formulas from
wrote in message
...
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

Protecting Formulas in cells
 

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

"Protecting Formulas from deletion" wrote:

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