Workbook.ListChangesOnNewSheet Property

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

Syntax

expression.ListChangesOnNewSheet

expression   A variable that represents a Workbook object.

Example

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

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

See Also

• Workbook Object
• Workbook Object Members
• HighlightChangesOnScreen Property
• HighlightChangesOptions Method