Hi

I have a worksheet (Excel 2003) on which I need to disable drag and drop.
Doing so within the worksheet_activate area as shown below works fine, BUT
doing this also prevents the user copying in data from another open workbook.

How can I disable drag and drop, but allow pasting from another workbook?

Thanks
dave

Private Sub Workbook_Activate()
Application.CellDragAndDrop = False
End Sub