Workbook.HighlightChangesOptions Method
Excel Developer Reference |
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.
Visual Basic for Applications |
---|
|
See Also