HighlightChangesOptions Method
Collapse the table of content
Expand the table of content
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

Workbook.HighlightChangesOptions Method

Controls how changes are shown in a shared workbook.

Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in microsoft.office.tools.excel.dll)

public virtual void HighlightChangesOptions (
	[OptionalAttribute] Object When,
	[OptionalAttribute] Object Who,
	[OptionalAttribute] Object Where



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


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.


An A1-style range reference that specifies the area to check for changes.

Optional Parameters

For information on optional parameters, see Understanding Optional Parameters in COM Interop.

© 2015 Microsoft