HypZoomOut
Describes the Oracle Smart View for Office VBA function, HypZoomOut.
Data provider types: Oracle Essbase, Planning (ad hoc only), Planning Modules (ad hoc only), Financial Consolidation and Close (ad hoc only), Tax Reporting (ad hoc only)
Description
HypZoomOut() collapses the view of data based on the selected members.
Syntax
HypZoomOut(vtSheetName, vtSelection)
ByVal vtSheetName As Variant
ByVal vtSelection As Variant
Parameters
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.
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
Private 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