C
Cleve
I have locked and protected a worksheet leaving only "Select unlocked cells"
checked. The problem is that if a user "moves" an entry in an unlocked cell,
either by ctrl X or drag and drop the cell references in the locked formulae
that referred to the original position change to the new position. Is there
any way of preventing this without turning off the drag and drop
functionality?
checked. The problem is that if a user "moves" an entry in an unlocked cell,
either by ctrl X or drag and drop the cell references in the locked formulae
that referred to the original position change to the new position. Is there
any way of preventing this without turning off the drag and drop
functionality?