Enable or Disable dragging and dropping cells in Excel
Sub Disable_Cell_Drag_Drop()
Application.CellDragAndDrop = False
End Sub
Application.CellDragAndDrop = True enables drag & drop
Friday, April 11, 2008
Download Windows Live Toolbar and personalize your Web experience! Add custom buttons to get the information you care about most.
Posts
Is there VBA code to prevent drag & drop of a worksheet into another workbook?
ReplyDeleteMany thanks
ReplyDeleteThat works fine to prevent dragging/dropping cells within the spreadsheet. It doesn't seem to prevent a worksheet being dragged and copied by clicking on the worksheet tab, holding down ctrl and dragging the worksheet.
this disables the drag and drop in the whole document.
ReplyDeletehow about in just one sheet, or only for a rage of cells in a sheet?