HighlightChangesOptions Method

See Also         Example         Applies To

Controls how changes are shown in a shared workbook.

Syntax

expression.HighlightChangesOptions(When, Who, Where)

expression   Required. An expression that returns a Workbook object.

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

Who   Optional Variant. 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   Optional Variant. An A1-style range reference that specifies the area to check for changes.