protecting cell references

[jmdingle]

Hi everyone! my problem is when a cell is inadvertently moved or
deleted in a spreadsheet, that cell reference is no longer valid and
the formulas that reference it, and all that follow, return error
values. All the formulas are protected and hidden, and the input cells
unprotected to allow data input. Am i protecting things incorrectly?

 

[JE McGimpsey]

Hi everyone! my problem is when a cell is inadvertently moved or
deleted in a spreadsheet, that cell reference is no longer valid and
the formulas that reference it, and all that follow, return error
values. All the formulas are protected and hidden, and the input cells
unprotected to allow data input. Am i protecting things incorrectly?

If you've protected the worksheet for contents (Tools/Protect/Protect
Worksheet..., check the contents checkbox), then you won't be able to
inadvertently move or delete a cell.