Workbook.PurgeChangeHistoryNow Method
| Excel Developer Reference |
Removes entries from the change log for the specified workbook.
Syntax
expression.PurgeChangeHistoryNow(Days, SharingPassword)
expression A variable that represents a Workbook object.
Parameters
| 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. |
Example
This example removes all changes that are more than one day old from the change log for the active workbook.
| Visual Basic for Applications |
|---|
|
See Also