This documentation is archived and is not being maintained.

Workbook.HighlightChangesOptions Method

Office 2007
Controls how changes are shown in a shared workbook.


expression.HighlightChangesOptions(When, Who, Where)

expression   A variable that represents a Workbook object.


NameRequired/OptionalData TypeDescription
WhenOptionalVariantThe changes that are shown. Can be one of the following XlHighlightChangesTime constants: xlSinceMyLastSave, xlAllChanges, or xlNotYetReviewed.
WhoOptionalVariantThe 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.
WhereOptionalVariantAn A1-style range reference that specifies the area to check for changes.


This example shows changes to the shared workbook on a separate worksheet.

Visual Basic for Applications
With ActiveWorkbook
    .HighlightChangesOptions _
        When:=xlSinceMyLastSave, _
    .ListChangesOnNewSheet = True
End With