다음을 통해 공유


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