How do you prevent users from changing certain cells?

  • Thread starter Thread starter Kelly
  • Start date Start date
K

Kelly

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.
 
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
 
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.
 
format the cell with the formula using the protection tab and locked and
hidden checked. Do the opposite to all the remaining cells.

Tools>Protect>worksheet make sure the "select locked cells" is not checked

Not only can't the cell with the formula be changed but now the formula is
not visible and the user can not click into the cell.
 
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
 
Back
Top