Data provider types: All
Resets visibility of the ribbon menus and menu items hidden on the sheet using HypHideRibbonMenu.
This function is supported for Office 2007 and above.
Public Declare Function HypHideRibbonMenuReset Lib "HsAddin" (ByVal vtSheetName As Variant) As Long
ByVal vtSheetName As Variant
vtSheetName: Input variable containing the sheet name on which the hidden menus and hidden menu items are to be reset to visible state. If vtSheetName is Null or Empty, the active worksheet is used.
Returns 0 if successful; otherwise, returns the appropriate error code.
Sub HideMenuReset() sts = HypHideRibbonMenuReset ("Sheet1") ‘Resets the visibility of menus and menu items hidden on this sheet End Sub