Workbook.ListChangesOnNewSheet (Excel)

True if changes to the shared workbook are shown on a separate worksheet.

ActiveWorkbook.ListChangesOnNewSheet = True