Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. Sub WorkSheet_Activate()
  2. Application.CommandBars.FindControl(ID:=21).Enabled = False
  3. End Sub
  4.  
  5. Option Explicit
  6. Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
  7. ByVal Target As Excel.Range)
  8.  
  9. Select Case Application.CutCopyMode
  10. Case Is = False
  11. 'do nothing
  12. Case Is = xlCopy
  13. 'do nothing
  14. Case Is = xlCut
  15. MsgBox "Please DO NOT Cut and Paste. Use Copy and Paste; then delete the source."
  16. Application.CutCopyMode = False 'clear clipboard and cancel cut
  17. End Select
  18.  
  19. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement