Hi,

Does someone know how to disable the right-click with a macro.
I would like to prevent the user using copy, past etc... in m
worksheets.

Thank you!

fre

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

Hi
on a worksheet basis you could use the following code in your worksheet
module:
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As
Boolean)
cancel=true
End Sub

--
Regards
Frank Kabel
Frankfurt, Germany


Hi,

Does someone know how to disable the right-click with a macro.
I would like to prevent the user using copy, past etc... in my
worksheets.

Thank you!

fred


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