How do you prevent users from changing certain cells?
format the cell with the formula using the protection tab and locked and
hidden checked. Do the opposite to all the remaining cells.
ToolsProtectworksheet 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.
"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.
|