Skip to Content
avatar image
Former Member

Disable or remove "Business Explorer" in the menu bar

Hi,

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Apr 17, 2006 at 08:25 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded