Partager via


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

See Also

Concepts

Workbook Object

Workbook Object Members