My spreadsheet workbook has protected sheets with some cells unlocked so that
other users can enter and edit information. I have protected formulas hidden
in other parts of the worksheets which refer to these cells as absolute
references. Everything works fine except when "cut" and "paste" are performed
on the unlocked cells, resulting in corrupted formulas. Obviously the simple
solution is to tell all users not to perform "cut" and "paste".
Frustratingly, this has not stopped it happening.
Is there a way to prevent the formulas from being corrupted when "cut" and
"paste" are performed?
From reading related discussions I suspect it requires VBASIC code, about
which I know very little.