HypSetMenu

Data provider types: Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management, Hyperion Enterprise

Description

In Excel 2007 and 2010, HypSetMenu( ) shows or hides the Smart View and data provider ribbons.

Syntax

HypSetMenu(bSetMenu)

ByVal bSetMenu As Boolean

Parameters

bSetMenu: Set to True to show the ribbons or menu. Set to False to hide the menu or ribbons.

Return Value

Returns 0 if successful; otherwise, the appropriate error code

Example

Declare Function HypSetMenu Lib "HsAddin" (ByVal bSetMenu As Boolean) As Long
Sub Example_HypSetMenu()
X=HypSetMenu(True)
End Sub