SAP Excel Business Explorer toolbar dissapeared

[former_member984749]

I ran an excel tool that included some add ins and toolbar customization and after exiting and entering BE Analyzer in Excel, the default buttons toolbar (is no longer showing. Can you please help me getting it back?

[former_member751964]

Welcome to the SAP Community! We wanted to give you the opportunity to take the tutorial to get started in SAP Community: https://developers.sap.com/tutorials/community-qa.html, as it provides tips for preparing questions that draw responses from our members. Additionally, by adding a picture to your profile you encourage readers to respond to your question. Learn more about your profile here: https://developers.sap.com/tutorials/community-profile.html

[MartinMaruskin]

Hi Carlos,

I think you need to check what is going on in your VBA that does customization of the BEx's toolbar.

Try to add following lines to you VBS code:

Application.CommandBars("BEx Analysis Toolbox").Visible = True
Application.CommandBars("BEx Design Toolbox").Visible = True

Setting these properties to value of true should enable the toolbar.

cheers

m./

[former_member984749]

Thanks a lot Martin. It worked perfectly.

[former_member231709]

Also see note 2109832 - "Start BEx Analyzer When MS Excel Starts" - an option to specify a registry value for this global setting