Paste text only

G

Guest

Put this code in the This Workbook Sheet in VB Editor:

Private Sub Workbook_Open()
avoid
End Sub

Then insert a Module and type the code below in the module:

Public Sub avoid()
Application.OnTime Now + TimeValue("00:00:01"), "avoid"
Application.CutCopyMode = False
End Sub

This will make cut/copy/paste almost impossible (user has
1 second to accomplish the whole thing).

If you want users to be able to paste value, write a code
for pasting values only which will disable
application.ontime temporarily. It could be added as an
right-click menu item. Too much code to put in here really.

Regards
-----Original Message-----
Since it seems to be quite an ordeal to turn off
Click to expand...
cut/copy/paste from a user, is it possible only to allow
the user to paste the cell value but not the formatting?
If this is not possible, can someone tell me a good place
to find code to turn off the cut/copy/paste. I have
looked and didn't have alot of luck. Thanks.
 
Top