View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Restrict copy paste ability

Hi

With code you can use this event in the Thisworkbook module

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
Application.CutCopyMode = False
End Sub

You must also disable drag and drop



--
Regards Ron de Bruin
http://www.rondebruin.nl


"wana be xl master" wrote in message
...
I have a protect sheet with only few cells where users can enter data.

Is there anyway to restrict users not to do a copy paste in those areas?

Any help greatly appreciated.

Thanks