HypSetMenu

Data source types: Essbase, Planning, Financial Management, Hyperion Enterprise

Description

HypSetMenu() removes or restores the Smart View menu from Excel.

Syntax

HypSetMenu(bSetMenu)

ByVal bSetMenu As Boolean

Parameters

bSetMenu: Boolean value indicating whether to remove or restore the Smart View menu for Excel. A True value indicates that the menu should be restored. A False value indicates that the menu should be removed.

Return Value

Returns 0 if successful. If the menu cannot be set, returns an error code.

Example

Declare Function HypSetMenu Lib "HsAddin" (ByVal bSetMenu As Boolean) As Long

Sub SetMyMenu()
   X=HypSetMenu(TRUE)
End Sub