ListChangesOnNewSheet Property

Applies To

Workbook object.

Description

True if changes to the shared workbook are shown on a separate worksheet. Read/write Boolean.

See Also

HighlightChangesOnScreen property, HighlightChangesOptions method.

Example

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

With ActiveWorkbook
    .HighlightChangesOptions When:=xlSinceMyLastSave, Who:="Everyone"
    .ListChangesOnNewSheet = True
End With