EssVSetMenu

Description

Removes or restores the Essbase menu from Excel.

Syntax

EssVSetMenu(setMenu)
ByVal setMenu As Boolean

Parameters

setMenu

Boolean value indicating whether to remove or restore the Essbase 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. Otherwise, it returns -31 if setMenu is True and the Essbase menu exists. It returns -30 if setMenu is False and the Essbase menu was removed.

Example

Declare Function EssVSetMenu Lib "ESSEXCLN.XLL" (ByVal setMenu As Boolean) As Long

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