View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Johnny Johnny is offline
external usenet poster
 
Posts: 126
Default Disable "Cut&Paste" and "Drag&Drop"

I want to disable this two function when I open a workbook. I've tryed both
this code:
Private Sub Workbook_Open()
Application.CellDragAndDrop = False
Application.CutCopyMode = False
End Sub

and

Private Sub WorkbookOpen(ByVal Wb As Workbook)
Application.CellDragAndDrop = False
Application.CutCopyMode = False
End Sub
but no one of them will work the right way. I've put it both in a module, in
"This workbook" and in the actuall sheet.
Anybody got an idea whats wrong?