S
Simon Lloyd
Hi all i have this code below that stops the user using right click on
cell how do i modify it so that they can not use right click on a shee
tab?
Regards,
Simon
Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVa
Target As Range, Cancel As Boolean)
ActiveWindow.DisplayHeadings = False
Cancel = True
ShortcutMenus(xlWorksheetCell).Enabled = False
MsgBox "You Can Only Use Your Left Mouse Button To Make Your Choice!"
vbExclamation, "Mouse Warning"
End Su
cell how do i modify it so that they can not use right click on a shee
tab?
Regards,
Simon
Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVa
Target As Range, Cancel As Boolean)
ActiveWindow.DisplayHeadings = False
Cancel = True
ShortcutMenus(xlWorksheetCell).Enabled = False
MsgBox "You Can Only Use Your Left Mouse Button To Make Your Choice!"
vbExclamation, "Mouse Warning"
End Su