Syntax

expression.ListChangesOnNewSheet

expression A variable that represents a Workbook object.

Example

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

Visual Basic for Applications 
With ActiveWorkbook .HighlightChangesOptions _ When:=xlSinceMyLastSave, _ Who:="Everyone" .ListChangesOnNewSheet = True End With
list list changes on new sheet List Changes On New Sheet Property List workbook changes on new sheet? listchanges listchangeson listchangesonnew ListChangesOnNewSheet ListChangesOnNewSheet Property Show changes made to shared workbook on separate sheet?

See also: