Paste
 

Hi tjh

You can clear the clipboard when the user go to sheet.
But when the user disable macro's this is not working

Try this event in the sheet module

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




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"tjh" wrote in message ...
hello,

How could I prevent my users from using the Paste funtion on a spreadsheet.
Is there a function that will do this, or do you know the vba code which
would prevent the user from pasting to a particular worksheet.

Thank You,