Welcome to VBA Tips & Tricks.
All VBA related information will be posted on this blog. Of late, VBA has been disregarded by many software professionals for .Net, c# and other technologies. This blog will also post articles related to them too
Happy reading
Pages
▼
Friday, April 11, 2008
Disable Drag & Drop of Cells in Excel VBA
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
That 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.
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?