How do you prevent users from changing certain cells?
Kelly
It sounds like the cell you refer to is not formatted for protection.
Try:
Tools Protection Unprotect sheet
Format Cells Protection tab 'click' on box against Locked to enter tick
Tools Protection Protect sheet
This should ptotect said cell
"Kelly" wrote:
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.
|