HypIsDataModified

Data source types: Essbase, Planning, Financial Management, Hyperion Enterprise

Description

HypIsDataModified() checks to see whether any data cells have been modified but not yet submitted.

Syntax

HypIsDataModified (vtSheetName [in])

By Val vtSheetName As Variant

Parameters

vtSheetName: For future use. Currently the active sheet is used.

Return Value

VARIANT_TRUE if the sheet contains any data cells that have been updated and not yet submitted, otherwise VARIANT_FALSE.

Example

Public Declare Function HypIsDataModified Lib "HsAddin" (ByVal vtSheetName As Variant) As Boolean

Sub TestIsSheetDirty()

		Dim oRet As Boolean

		oRet = HypIsDataModified(Empty)
		MsgBox (oRet)

End Sub