Workbook.HighlightChangesOptions Method (Excel)
Controls how changes are shown in a shared workbook.
Syntax
expression .HighlightChangesOptions(When, Who, Where)
expression A variable that represents a Workbook object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
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. |
Example
This example shows changes to the shared workbook on a separate worksheet.
With ActiveWorkbook
.HighlightChangesOptions _
When:=xlSinceMyLastSave, _
Who:="Everyone"
.ListChangesOnNewSheet = True
End With