or you can use data validation to "lock" a cell here & there (if your
users won't know how to unlock it). just choose custom & then in the
formula i use =0 (so anything they enter is "wrong"), & then in the
error alert i choose "stop" with a message that says "Formula cell.
No manual entry allowed!"
just an idea
susan


On Mar 12, 1:10*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
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.- Hide quoted text -

- Show quoted text -