Originally Posted by
brettdj
While in this vein do we have a volunteer to write up the Disable Copy functionality etc(Menus, Icons, Keyboard shortcuts and right click)
Jeroen?
Cheers
Dave
Disabling copy is actually rather difficult since there are many ways to copy. Drag & Drop for example is not really thought of as copying (at least by me) but it is.
When I don't want people to paste I use a worksheet selection change event, then just run the code:
Application.CutCopyMode = False
But to specifically answer your question, this will disable the copy from the edit menu, standard toolbar, and right click menu.
Application.CommandBars("Standard").Controls("&Copy").Enabled = False
Application.CommandBars("Worksheet Menu Bar").Controls("&Edit").Controls("&Copy").Enabled = False
Application.CommandBars("Cell").Controls("&Copy").Enabled = False