In the thisworkbook module

Private Sub Workbook_SheetBeforeRightClick( _
ByVal Sh As Object, ByVal Target As Excel.Range, _
Cancel As Boolean)
Cancel = True
End Sub


look at help in VBA at OnKey to see how to redefine Ctrl+C, Ctrl+V and
Ctrl+X

--
Regards,
Tom Ogilvy


"Celtic_Avenger " wrote in
message ...
If it is possible...........

Is there any way using VBA that I can disable the right mouse
button......Why.......I need to stop users from being able to use the
copy and paste functions both on the mouse and on the keyboard
shortcuts.

Is there a way to do either or both of these?

Thanks

Celtic_Avenger



---
Message posted from http://www.ExcelForum.com/