HypSetMenu
Describes the Oracle Smart View for Office VBA function, HypSetMenu.
Cloud data provider types: Oracle Analytics Cloud - 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 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