Thread: PROTECT FORMULA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default PROTECT FORMULA

See help on sheet protection and protecting individual cells.

Basics are you lock the cells you don't want edited then protect the
worksheet with a password.

Just be aware that Excel internal security is very weak and passwords easily
cracked.

But to protect cells from inadvertant change it is sufficient.


Gord Dibben MS Excel MVP


On Fri, 12 Jun 2009 15:17:01 -0700, Donna
wrote:

I want to protect the formulas in the worsheet so that they can not be
deleted or changed.