Data provider types: Oracle Essbase, Oracle Hyperion Planning, Oracle Planning and Budgeting Cloud, Oracle Hyperion Financial Management, Oracle Hyperion Enterprise®
Description
HypIsDataModified() determines whether any data cells have been modified but not yet submitted.
Syntax
HypIsDataModified (vtSheetName)
By Val vtSheetName 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.
Return Value
Returns True if the worksheet contains any data cells that have been modified but not yet submitted; otherwise, False.
Example
Public Declare Function HypIsDataModified Lib "HsAddin" (ByVal vtSheetName As Variant)As Boolean Sub Example_HypIsDataModified() Dim oRet As Boolean oRet = HypIsDataModified(Empty) MsgBox (oRet) End Sub