URGENT Help required Please!

[Helix242]

Hi all,

I hope you can provide some urgent help. I was trying to disable the Paste options and used the following code in the Worksheet

Private Sub Worksheet_Activate()
Application.CutCopyMode = FALSE
End Sub

Private Sub Worksheet_Deactivate()
Application.CutCopyMode = TRUE
End Sub

This did disable the Paste option, but in ALL workbooks, and the Paste Option is still greyed out. Can anyone help to enable this option again??

Thank you in advance!

 

[Helix242]

It is okay, I put this in a Module and it has worked fine! Thank you