Protecting Formulas

F

FP Novice

Hi,
Is there a way to protect formulas in cells from being changed without
removing rights to edit the document?

Thanks
 
D

David Billigmeier

Follow each step below:

Ctrl-A
Ctrl-A
<Format>
<Cells>
"Protection" tab
Uncheck "Locked"
Click OK
Ctrl-A
Ctrl-A
F5
Click "Special"
Check "Formulas"
Click OK
<Format>
<Cells>
"Protection" tab
Check "Locked"
Click OK
<Tools>
<Protection>
<Protect Sheet>
Click OK

Does that help?
 
F

FP Novice

It worked perfectly, thank you very much David.

David Billigmeier said:
Follow each step below:

Ctrl-A
Ctrl-A
<Format>
<Cells>
"Protection" tab
Uncheck "Locked"
Click OK
Ctrl-A
Ctrl-A
F5
Click "Special"
Check "Formulas"
Click OK
<Format>
<Cells>
"Protection" tab
Check "Locked"
Click OK
<Tools>
<Protection>
<Protect Sheet>
Click OK

Does that help?
Click to expand...
 
Top