Why is it that when you protect a worksheet so that formulas
CANNOT be changed, which works great, until a person drags and drops a cell
that is NOT protected because info needs to be typed in that cell, The drag
and drop corrupts the formulas in the cells where the person dragged and
dropped the info. I know you can uncheck the drag and drop box under
Tools/Options, but that makes the change to any spreadsheets you open. You
cannot save that tools/option just to the worksheet you have open.