Workbook.HighlightChangesOptions Method

Controls how changes are shown in a shared workbook.

Namespace:  Microsoft.Office.Tools.Excel
Assemblies:   Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

Syntax

'Declaration
Sub HighlightChangesOptions ( _
    When As Object, _
    Who As Object, _
    Where As Object _
)

void HighlightChangesOptions(
    Object When,
    Object Who,
    Object Where
)

Parameters

• When
  Type: System.Object

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

• Who
  Type: System.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

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

Remarks

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

.NET Framework Security

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

See Also

Reference

Workbook Interface

Microsoft.Office.Tools.Excel Namespace