View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Billigmeier David Billigmeier is offline
external usenet poster
 
Posts: 176
Default 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