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
 
You must log in or register to reply here.

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

Similar Threads

Formula 8
Excel Shortcut 2
delete rows 1
CF for next month/this year 3
Disable Unfreeze Panes and Remove Split, how? 2
Alternative program to Excel for array formulas 2
Formula in Cell Instead of Result 3
Password a Macro so certain users can press it 2

Back
Top