protecting a formula

[kap78]

Hi. I am trying to protect a formula to an Excel workbook that I a
going to be sharing via email. The formula's keep getting deleted b
other users, and I need them to stay. Every time I try to do this, i
tells me I have to protect the sheet. When I protect the sheet i
becomes read-only. I don't want it to be read only, it is a dail
sales sheet and the other users need to enter their information in an
send it back to me. Everytime I get it sent back, the formulas hav
been deleted, by the user. How can I just protect single cells? I
there a way? Please Help!!!! :eek

 

[Arvi Laanemets]

Hi

Before you protect sheet, you have to unlock cells users are allowed to edit
(Format.Cells.Protection tab)

1. way:
Select entire sheet, select Format.Cells.Protection, check Locked for all
cells (it's default option btw.) and press OK. Select cell(s) you want allow
users to edit, select Format.Cells.Protection, uncheck Locked for selected
cells and press OK. Protect sheet.

2. way:
Select entire sheet, select Format.Cells.Protection, uncheck Locked for all
cells and press OK. Select cell(s) you want to restrict to edit by users,
select Format.Cells.Protection, check Locked for selected cells and press
OK. Protect sheet.


Arvi Laanemets