PROTECT FORMULA

  • Thread starter Thread starter Donna
  • Start date Start date
D

Donna

I want to protect the formulas in the worsheet so that they can not be
deleted or changed.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top