ExcelBanter - View Single Post - Need to Customize Workbook tabs Context Menu

JE McGimpsey

Try the "Ply" bar

In article .com,
wrote:

Can anyone tell me how to access the Workbook tabs context menu?

I thought I had found the right menu name but when I run the following
code I just get the list of tab names when I thought I would get the
list of context menu items...

Sub Macro1()
Dim i As Integer
Dim x As Integer
Application.CommandBars("Workbook tabs").Reset

With Application.CommandBars("Workbook tabs")
i = .Controls.Count
For x = 1 To i
Debug.Print .Controls(x).Caption
Next
End With
End Sub

I need to prevent the user from changing the structure of the workbook
so I'd like to remove/disable this menu completely if possible.

Kind regards,
Nick.