Alright, not sure how familiar you are with VBA... so Ill give you a detailed
instruction. Go to the VBE (Visual Basic Editor)

In the Project Explorer to the left, select the workbook that has the
worksheet... then double click on the worksheet that you want protected.

A module should open

On the drop down list on the top left of the Module that says (General)...
select "Worksheet"

Some private sub function should pop up. Delete that and insert this sub.

Private Sub Worksheet_Activate()

Application.CellDragAndDrop = False

End Sub

Then Below this enter this function

Private Sub Worksheet_Deactivate()

Application.CellDragAndDrop = True

End Sub

Make sure you copy and paste this word for word... there should be nothing
else on the module... and make sure you double click on the worksheet and not
just insert a new module... and make sure you select worksheet. What this
does is anytime someone opens that worksheet Cell Drag and Drop is turned
off... whenever someone leaves that worksheet Cell Drag and Drop is turned
on. Let me know if you have any other quesitons.


"DennisK" wrote:

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.