Workbook.PurgeChangeHistoryNow method (Excel)
Removes entries from the change log for the specified workbook.
expression.PurgeChangeHistoryNow (Days, SharingPassword)
expression A variable that represents a Workbook object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Days | Required | Long | The number of days that changes in the change log are to be retained. |
| SharingPassword | Optional | Variant | 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. |
This example removes all changes that are more than one day old from the change log for the active workbook.
VB
ActiveWorkbook.PurgeChangeHistoryNow Days:=1
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.