Syntax

expression.ChangeHistoryDuration

expression A variable that represents a Workbook object.

Remarks

Any changes in the change history older than the setting for this property are removed when the workbook is closed.

Example

This example sets the number of days shown in the change history for the active workbook if change tracking is enabled. Any changes in the change history older than the setting for this property are removed when the workbook is closed.

Visual Basic for Applications 
With ActiveWorkbook If .KeepChangeHistory Then .ChangeHistoryDuration = 7 End If End With
change change history duration Change History Duration Property Change the amount of change history saved? changehistory ChangeHistoryDuration ChangeHistoryDuration Property Find out time period for saving workbook changes? Set the number of days change history is saved?

See also: