Data provider types: Essbase, Planning, Financial Management, Hyperion Enterprise
HypIsDataModified() determines whether any data cells have been modified but not yet submitted.
HypIsDataModified (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 contains any data cells that have been modified but not yet submitted; otherwise, False.
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