_Workbook.HighlightChangesOptions Method

Controls how changes are shown in a shared workbook.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Sub HighlightChangesOptions ( _
    When As Object, _
    Who As Object, _
    Where As Object _
)
'Usage
Dim instance As _Workbook
Dim When As Object
Dim Who As Object
Dim Where As Object

instance.HighlightChangesOptions(When, _
    Who, Where)
void HighlightChangesOptions(
    Object When,
    Object Who,
    Object Where
)

Parameters

  • When
    Type: System.Object

    Optional Object. The changes that are shown. Can be one of the following XlHighlightChangesTime constants: xlSinceMyLastSave, xlAllChanges, or xlNotYetReviewed.

  • Who
    Type: System.Object

    Optional Object. The user or users whose changes are shown. Can be "Everyone", "Everyone but Me", or the name of one of the users of the shared workbook.

  • Where
    Type: System.Object

    Optional Object. An A1-style range reference that specifies the area to check for changes.

See Also

Reference

_Workbook Interface

_Workbook Members

Microsoft.Office.Interop.Excel Namespace