The protection feature for the workbook works in connection with Format/
Cells/ Protection to allow you to lock or unlock particular cells, and thus
govern whether users can change the cell contents. If the cell is locked
and the sheet protected, the formula can't be changed.
--
David Biddulph

"Kelly" wrote in message
...
I would like to allow users to change certain cells but not the formulas in
other cells. The "Protection" feature doesn't prevent someone from
changing
one of the cells with formulas.
Thanks.