Workbook.PurgeChangeHistoryNow Method (Excel)
Removes entries from the change log for the specified workbook.
Syntax
식 .PurgeChangeHistoryNow(Days, SharingPassword)
식 A variable that represents a Workbook object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
---|---|---|---|
Days |
필수 |
Long |
The number of days that changes in the change log are to be retained. |
SharingPassword |
선택 |
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.
ActiveWorkbook.PurgeChangeHistoryNow Days:=1