Export (0) Print
Expand All

Workbook.HighlightChangesOptions Method

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

Syntax

expression.HighlightChangesOptions(When, Who, Where)

expression   A variable that represents a Workbook object.

Parameters

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.

Example

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

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



Community Additions

ADD
Show:
© 2014 Microsoft