Workbook.ListChangesOnNewSheet Property (Excel)
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