I have a worksheet A , in which I want to disable dragging functionality for a particular range of cells. for eg: D24 to D100
All other columns and cells in the sheet should be allowed to drag.
Found this code, but its for the complete workbook :
Private Sub Workbook_Activate()
Application.CellDragAndDrop = False
End Sub
All other columns and cells in the sheet should be allowed to drag.
Found this code, but its for the complete workbook :
Private Sub Workbook_Activate()
Application.CellDragAndDrop = False
End Sub