Data provider types: Essbase, Planning, Financial Management, Hyperion Enterprise
In Excel 2007 and 2010, HypSetMenu( ) shows or hides the Smart View and data provider ribbons. In Excel 2003, HypSetMenu( ) shows or hides the Smart View menu.
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