Hi All,

I want to disable right click in a workbook but allow the
user to make a copy of any sheet into another book. How
can I achieve these? Thanks.

In the sheet modules of the sheets where you don't want a right click
capability put in a BeforeRightClick event

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As
Boolean)
Cancel = True
End Sub

--
Regards,
Tom Ogilvy


wrote in message
...
Hi All,

I want to disable right click in a workbook but allow the
user to make a copy of any sheet into another book. How
can I achieve these? Thanks.