Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?

Former Member
Former Member replied

hi MSTF,

try this

Sub Disable_BEx()

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

End Sub

hope this helps.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question