PDA

View Full Version : Sleeper: Script remove the toolbar from excel



QAZWSX1
07-09-2015, 12:24 AM
Hello


Maybe you please help me
i have office 2010
Is it possible to create a script for Visual Basic for Application
I will explain myself more


when i open excel is open excel with add-in called BExAnalyzer.xla
In this add-in has two toolbar
1. toolbar Analysis
2. toolbar Design
Now I want to remove the toolbar for Design -What I have been told that in order to remove Sap I have to press Alt + F11 to Excel and then exceeds the total of
microsoft visual basic for application where run the command



Public Sub Test ()
Application.CommandBars ("BEx Analysis Toolbox"). Visible = True
Application.CommandBars ("BEx Design Toolbox"). Visible = False


Now I want to create a script to do it for all computer users while login




the location xla file is C:\Program Files (x86)\Common Files\SAP Shared\BW\BExAnalyzer.xla"


Thank you very much