Data provider types: Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management, Hyperion Enterprise
HypIsFreeForm() determine whether the worksheet is in free-form mode.
HypIsFreeForm (vtSheetName)
By Val vtSheetName As Variant
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.
Returns True if the worksheet is in free-form state; otherwise, returns False.
Public Declare Function HypIsFreeForm Lib "HsAddin" (ByVal vtSheetName As Variant) As Boolean Sub Example_HypIsFreeForm() Dim oRet As Boolean oRet = HypIsFreeForm(Empty) MsgBox (oRet) End Sub