Data provider types: Essbase, Financial Management, Planning, Hyperion Enterprise
HypSetGlobalOption() sets global Smart View options. Global options are options that apply to the entire current workbook and to any workbooks and worksheets that are created henceforth.
See also HypSetOption.
HypSetGlobalOption(vtItem, vtGlobalOption)
ByVal vtGlobalOption As Variant
vtItem: The number that indicates which option is to be set. See Table 4, HypGetGlobalOption Parameter Numbers and Options for values.
vtGlobalOption: A variant which can take a Boolean, Number, or Text value denoting the option being set for vtItem. If Null or Empty, no action is performed.
Returns 0 if successful; otherwise, returns the appropriate error code.
The following example sets the option to display no messages.
Declare Function HypSetGlobalOption Lib "HsAddin" (ByVal vtItem As Long, ByVal vtGlobalOption As Variant) As Long Sub Example_HypSetGlobalOption() X=HypSetGlobalOption(5, 3) If X=0 Then MsgBox("Message level is set to 3 - No messages") Else MsgBox("Error. Message level not set.") End If End Sub