Disable or remove "Business Explorer" in the menu bar
I'm using BEx Analyzer and tring to disable some controls in BEx toolbar. I got some helpful information from the following thread Bex Analyzer Toolbar in Excel and now I can grey out some toolbar buttons. But I found there is also a "Business Explorer" in the top menu bar. Does anyone know how to disable or remove that?
Dim CmdBar As CommandBar
Dim CmdBarMenu As CommandBarControl
' Point to the Worksheet Menu Bar
Set CmdBar = Application.CommandBars("Worksheet Menu Bar")
' Point to the BEx menu on the menu bar
Set CmdBarMenu = CmdBar.Controls("Business Explorer")
'to disable menu "Business Explorer"
CmdBarMenu.Enabled = False
'to hide/'remove' menu "Business Explorer"
CmdBarMenu.Visible = False
hope this helps.