HypSetMenu

Describes the Oracle Smart View for Office VBA function, HypSetMenu.

Cloud data provider types: Oracle Essbase, Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting

On-premises data provider types: Oracle Essbase, Oracle Hyperion Planning, Oracle Hyperion Financial Management

Description

In Excel, 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