PROTECT FORMULA

D

Donna

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

Gord Dibben

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
 
Top