Data provider types: Essbase, Planning, Financial Management, Hyperion Enterprise
HypSetSheetOption() sets sheet level options.
Note: | You can set only one option at a time. |
HypSetSheetOption(vtSheetName, vtItem, vtOption)
ByVal vtSheetName As Variant
ByVal vtItem As Variant
ByVal vtOption As Variant
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.
vtItem: The number that indicates which option is to be set. See Table 5, Options for vtItem for a list of values.
vtOption: The new value of the item.
Returns 0 if successful; otherwise, returns the appropriate error code.
Declare Function HypSetSheetOption Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtItem As Variant, ByVal vtOption As Variant) As Long Sub Example_HypSetSheetOption() X=HypSetSheetOption(Empty, 6, FALSE) If X=0 Then MsgBox("#Missing values will appear. ") Else MsgBox("Error. #Missing option not set.") End If End Sub