HighlightChangesOptions Method Example

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

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