Data provider types: Oracle Essbase, Oracle Hyperion Planning, Oracle Planning and Budgeting Cloud, Oracle Hyperion Financial Management
Description
In Excel 2007 and 2010, HypSetMenu( ) shows or hides the Oracle Smart View for Office 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