Workbook.ListChangesOnNewSheet Property (Excel)

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

Syntax

식 .ListChangesOnNewSheet

식 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

참고 항목

개념

Workbook Object

Workbook Object Members