ExcelBanter - Protecting Formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Protecting Formulas (https://www.excelbanter.com/excel-discussion-misc-queries/103760-protecting-formulas.html)

FP Novice

Protecting Formulas

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

Thanks

David Billigmeier

Protecting Formulas

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?
--
Regards,
Dave

"FP Novice" wrote:

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

Thanks

FP Novice

Protecting Formulas

It worked perfectly, thank you very much David.

"David Billigmeier" wrote:

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?
--
Regards,
Dave

"FP Novice" wrote:

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

Thanks

All times are GMT +1. The time now is 04:23 AM.