Delete Customize item in the shortcut menu in Execl 1

[Bitaoo]

Hello guys,

Does anybody know how can I invisible the Customize...
item on the shortcut menu in Excel? As you know when
you right-click a button on any toolbar or the menu bar
in Excel you will see the shortcut menu.

Thanks for your help in advance.
--Bita

 

[Bowers74]

Hi,

The following bit of code will Toggle the "visibility" of the complete shortcut menu that pops-up when you right-click a toolbar, and the Menu View->Toolbars:

Sub ToggleToolbarsCustomize2()
Dim tb As CommandBar
Set tb = CommandBars("Toolbar List")
tb.Enabled = Not tb.Enabled
End Sub

I hope this helps!


Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[Bitaoo]

Thanks a lot.

--Bita