April 2006
Beginner
1114 pages
98h 16m
English
workbook.ChangeHistoryDuration [= setting]
For shared workbooks, sets or returns the number of days changes are tracked. The KeepChangeHistory property must be True for this property to have an effect. The following code tracks changes for seven days if the workbook is shared:
If ThisWorkbook.MultiUserEditing Then
ThisWorkbook.KeepChangeHistory = True
ThisWorkbook.ChangeHistoryDuration = 7
End IfRead now
Unlock full access