Skip to Content
0

How to show / hide AO task pane via macro

Jul 14, 2017 at 02:23 PM

92

avatar image

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...

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Oct 17, 2017 at 11:04 AM
0

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")
Share
10 |10000 characters needed characters left characters exceeded
Klaus Franz Feb 13 at 07:41 AM
0

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...

Share
10 |10000 characters needed characters left characters exceeded