Data provider types: Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management, Hyperion Enterprise
In Excel 2007 and 2010, HypSetMenu( ) shows or hides the Smart View and data provider ribbons.
HypSetMenu(bSetMenu)
ByVal bSetMenu As Boolean
bSetMenu: Set to True to show the ribbons or menu. Set to False to hide the menu or ribbons.
Returns 0 if successful; otherwise, the appropriate error code
Declare Function HypSetMenu Lib "HsAddin" (ByVal bSetMenu As Boolean) As Long Sub Example_HypSetMenu() X=HypSetMenu(True) End Sub