Hide menu items
Hi,
You can use the worksheet event before right click.
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As
Boolean)
If Environ("Username") < "USER" Then
Cancel = True
End If
End Sub
Mike
"Cresta" wrote:
Hello
Could some one point me in the right direction please.
By right clicking on a sheet tab a context menu pops up, I need to hide this
menu so it is not available for a particular file for ceratain uses. I'm
guessing I would us XXX_getVisible callback, but I dont know how to reference
the menu.
Thanks
|