Cloud data provider types: Oracle Analytics Cloud - Essbase, Oracle Planning and Budgeting Cloud
On-premises data provider types: Oracle Essbase, Oracle Hyperion Planning, Oracle Hyperion Financial Management
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