Guest User

Untitled

a guest
Dec 17th, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.01 KB | None | 0 0
  1. Private Sub Workbook_Activate()
  2. Application.CutCopyMode = False
  3. Application.OnKey "^c", ""
  4. Application.CellDragAndDrop = False
  5. End Sub
  6. Private Sub Workbook_Deactivate()
  7. Application.CellDragAndDrop = True
  8. Application.OnKey "^c"
  9. Application.CutCopyMode = False
  10. End Sub
  11. Private Sub Workbook_WindowActivate(ByVal Wn As Window)
  12. Application.CutCopyMode = False
  13. Application.OnKey "^c", ""
  14. Application.CellDragAndDrop = False
  15. End Sub
  16. Private Sub Workbook_WindowDeactivate(ByVal Wn As Window)
  17. Application.CellDragAndDrop = True
  18. Application.OnKey "^c"
  19. Application.CutCopyMode = False
  20. End Sub
  21. Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
  22. Application.CutCopyMode = False
  23. End Sub
  24. Private Sub Workbook_SheetActivate(ByVal Sh As Object)
  25. Application.OnKey "^c", ""
  26. Application.CellDragAndDrop = False
  27. Application.CutCopyMode = False
  28. End Sub
  29. Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
  30. Application.CutCopyMode = False
  31. End Sub
Add Comment
Please, Sign In to add comment