How to show / hide AO task pane via macro

[klaus_franz]

How can I show / hide the complete task pane in Analysis Office via Excel macro?

I want to leave it hidden by default (for "normal" users) but want to show it automatically in certain AO workbooks (for "expert" users).

Using just SAPExecuteCommand / Hide / TaskPane / ... only hides single parts of the task pane but not the complete taks pane...

[klaus_franz]

I want to hide the complete design panel (task pane), but not the ribbon. Just like I can do by selecting "Display", then show/hide design panel in the "design panel group" of the ribbon. Meanwhile I was able to hide the design panel via (undocumented) command:

lResult = Application.Run("SAPExecuteCommand", "Hide", "TaskPane", "All")

But I was not able to show the design panel again, command "Show", "TaskPane", "Default" does not work in this case...

[Former Member]

What do you want to hide exactly? Taskpane only hides the differents tabs in the design panel (e.g. Components). If you want to hide the complete Analysis-ribbon in excel, you have to use "Ribbon" instead of taskpane:

Dim lResult
lResult = Application.Run("SAPExecuteCommand", "Hide", "Ribbon", "All")