Protecting certain cells

  • Thread starter Thread starter Tdinova
  • Start date Start date
T

Tdinova

I am using formulas to get averages , standard deviation and other
figurers... I want to be able to lock the cell so others cannot change my
formula but be able to change certain values to get averages and other
information ....


I was trying to use the protection under tools to no hope...


any help would be appreciated



--
 
In Excel, cells are either locked or unlocked; the default is locked. If a worksheet
is not protected, there is no difference in behavior, but if you protect the
worksheet, the locked cells are protected, but the unlocked cells can be edited.

What you need to do is unlock all cells except for the ones you want to protect,
then protect the workbook. Don't bother with a password, unless the users are really
dense. The warning will be a simple reminder that there's a formula you don't want
to break.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top