Workbook.PurgeChangeHistoryNow (Excel)

Removes entries from the change log for the specified workbook.

PurgeChangeHistoryNow (Days, SharingPassword)

Dim lngDays As Long: lngDays = 
ActiveWorkbook.PurgeChangeHistoryNow Days:=lngDays


The following argument is required

Days (Long) - The number of days that changes in the change log are to be retained.

The following argument is optional

SharingPassword - The password that unprotects the workbook for sharing. If the workbook is protected for sharing with a password and this argument is omitted, the user is prompted for the password