I have locked all the cells in column B as it is calculating a formula. Columns A and C contain unlocked data that feeds into column B. If you select cells in column A and drag it across to C and hit "delete," it deletes the information and therefore the formula in column B, despite the fact that it is locked.

Any thoughts on how to prevent this from happening? I am trying to make this spreadsheet as 'idiot-proof' as possible, and just know someone is going to delete the formula on accident...any thoughts?

Thanks in advance!