Undocumented TaskPane functionality – Hiding the Information Tab

The Analysis documentation shows you how to hide the Analysis tab and/or the Components tab of the task pane, and it also shows you how to show/restore all tabs. The Information tab, however, isn’t documented as a tab that can be hidden. The Information tab can be hidden though, if you provide the right parameter to the SAPExecuteCommand function.

The 2 documented “hide” calls are:

Application.Run(“SAPExecuteCommand”, “Hide”, “TaskPane”, “Analysis”)

Application.Run(“SAPExecuteCommand”, “Hide”, “TaskPane”, “Components”)

The undocumented “hide” call is:

Application.Run(“SAPExecuteCommand”, “Hide”, “TaskPane”, “Information”)

It is worth nothing that while it is possible to call the hide function against all 3 tabs, only 2 of the 3 tabs can be hidden effectively, as any attempt to hide the 3rd tab will result in the rendered “tab” outline being hidden, but the contents of the 3rd tab will remain visible. But at least that lets you hide any 2 of the 3, and include the Information tab as one of the two tabs that are hidden.

This functionality was tested under SBO 1.4 and Office 2007. You might experience different results in other versions of Analysis/Excel.

CAUTION: This is undocumented behaviour, and as such, may lead to instability/corruption of the Analysis Add-in, your Analysis workbooks and/or Excel. It is not likely to be supported by SAP or Microsoft. It may not be available in future versions of Analysis. Use at your own risk.