Skip to Content

How to show / hide AO task pane via macro

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    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")
    Add comment
    10|10000 characters needed characters exceeded

  • Feb 13 at 07:41 AM

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

    Add comment
    10|10000 characters needed characters exceeded