Edit

Share via

Workbook.ChangeHistoryDuration property (Excel)

  • Article

Returns or sets the number of days shown in the shared workbook's change history. Read/write Long.

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.

With ActiveWorkbook 
 If .KeepChangeHistory Then 
 .ChangeHistoryDuration = 7 
 End If 
End With

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.