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
Ron de Bruin - 22 Feb 2006 19:11 GMT
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

Signature
Regards Ron de Bruin
http://www.rondebruin.nl
>I have a protect sheet with only few cells where users can enter data.
>
[quoted text clipped - 3 lines]
>
> Thanks
Jim Thomlinson - 22 Feb 2006 19:11 GMT
Here is some selection change code that you need to put into the specified
sheet...
(Right click the sheet tab and select Veiw Code)
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
with Application
If .CutCopyMode = xlCopy Then .CutCopyMode = False
If .CutCopyMode = xlCut Then .CutCopyMode = False 'Prevents Cut
end with
End Sub

Signature
HTH...
Jim Thomlinson
> I have a protect sheet with only few cells where users can enter data.
>
[quoted text clipped - 3 lines]
>
> Thanks
wana be xl master - 22 Feb 2006 19:24 GMT
Owesome....Thanks to Ron and Jim
:)
> I have a protect sheet with only few cells where users can enter data.
>
[quoted text clipped - 3 lines]
>
> Thanks