Hide menu items

[Cresta]

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

 

[Mike H]

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

 

[Mike H]

Apologies I misread your post this disbale right click on worksheet not the
sheet tab.

Mike

 

[Mike H]

Wrapped in a suitable if statement his disable the right click on the sheet tab

Application.CommandBars("Ply").Enabled = False

Re-Enable with true

Mike

 

[Gord Dibben]

Application.CommandBars("Ply").Enabled = False ' True


Gord Dibben MS Excel MVP

 

[Cresta]

Thanks, that worked a treat.