Data provider types: Essbase, Planning (ad hoc only), Financial Management (ad hoc only), Hyperion Enterprise (ad hoc only)
HypZoomOut() collapses the view of data based on the selected members.
HypZoomOut(vtSheetName, vtSelection)
ByVal vtSelection As Variant
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.
vtSelection: The range object that refers to the members to be zoomed out on. If the selection is Null or Empty, the active cell is used.
Returns 0 if successful; otherwise, returns the appropriate error code.
Declare Function HypZoomOut Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtSelection As Variant) As Long Sub Example_HypZoomOut() X=HypZoomOut(Empty, RANGE("B3")) If X = 0 Then MsgBox("Zoom out successful.") Else MsgBox("Zoom out failed.") End If End Sub