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
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
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
--
HTH...
Jim Thomlinson
"wana be xl master" wrote:
> 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
>
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" <[email protected]> wrote in message
news:[email protected]...
>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
>
Owesome....Thanks to Ron and Jim
"wana be xl master" wrote:
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks