Data provider types: All
Description
Resets visibility of the ribbon menus and menu items hidden on the sheet using HypHideRibbonMenu.
This function is supported for Office 2007 and above.
Syntax
Public Declare Function HypHideRibbonMenuReset Lib "HsAddin" (ByVal vtSheetName As Variant) As Long
ByVal vtSheetName As Variant
Parameters
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.
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
Sub HideMenuReset()
sts = HypHideRibbonMenuReset ("Sheet1")
‘Resets the visibility of menus and menu items hidden on this sheet
End Sub