Thread: Cut and Copy
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Cut and Copy

Use the selection change event to clear the clipboard.

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Application.CutCopyMode = False
End Sub

Not familiar with events:

Chip Pearson's page on Events
http://www.cpearson.com/excel/events.htm
--
Regards,
Tom Ogilvy
"Richard Burgers" wrote in message
...
How do I prevent Cut, Copy and Paste but do allow data entry in a field.