This documentation is archived and is not being maintained.

ListChangesOnNewSheet Property [Excel 2003 VBA Language Reference]

Office 2003

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


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

With ActiveWorkbook
    .HighlightChangesOptions _
        When:=xlSinceMyLastSave, _
    .ListChangesOnNewSheet = True
End With

Applies to | Workbook Object

See Also | HighlightChangesOnScreen Property | HighlightChangesOptions Method