Data provider types: All
Description
Hides ribbon menus and menu items. Also hides context ribbon menus and menu items based on sheet input.
Smart View ribbon customization is applicable for any sheet. Context ribbon customization is sheet-based.
This function is supported for Office 2007 and above.
Syntax
Public Declare Function HypHideRibbonMenu Lib "HsAddin" (ByVal vtSheetName As Variant, ParamArray vtMenus() As Variant) As Long
ByVal vtSheetName As Variant
ParamArray vtMenus() As Variant
Parameters
vtSheetName: Input variable containing the sheet name on which ribbon menus and menu items are to be hidden. If vtSheetName is Null or Empty, the active worksheet is used.
vtMenus: Input variable containing ribbon menu names and menu item names to be hidden.
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code. A common error code for this function is -73 (ambiguity).
Example
Sub HideMenus()
sts = HypHideRibbonMenu ("Sheet1", "Smart View->Submit Data", "Panel")
sts = HypHideRibbonMenu("Sheet1", "Smart View->Refresh->Refresh")
‘Hides the submenu item Refresh under the Refresh split button
sts = HypHideRibbonMenu("Sheet1", "Essbase->POV", "Smart View->Copy", "Essbase->Same Workbook")
‘Hides menu items for different ribbons on the same sheet
End Sub