Is there a way to initiate “track changes” through VBA in Excel?

Question

I want VBA to start / stop the Change Tracking features in Excel.

Search through the network I saw a property called an TrackRevisionsobject ActiveDocument. Supposedly, the ActiveDocument.TrackRevisions = True"Change Tracking" should be included in the MS Word letter .

But in MS Excel, this line gives a 424 Object requiredruntime error. The same error is returned when trying with ThisWorkbook. The change ActiveSheetresults in an error 438 Object doesn't support this property or method.

Answer 1

For a general book, you can use VBA from these links (method ) ActiveWorkbook.HighlightChangesOptions

• HighlightChangesOptions VBA Excel 2003
• Workbook.HighlightChangesOptions Method Office 2007
• Workbook.HighlightChangesOptions Method (Excel) Office 2010

, Word, , Excel:

• .
• . , , , , .
• .

, , VBA

, , .

Answer 2

. .

    With ActiveWorkbook
    .HighlightChangesOptions When:=xlAllChanges
    .ListChangesOnNewSheet = False
    .HighlightChangesOnScreen = True
   End With

Answer 3

- , . , , , , , , . , .

... , Microsoft Spreadsheet ( Excel 2013, Excel 2016, Office 365 Professional).

... , ( ) - XLTools Version Control.

.