Workbook.PurgeChangeHistoryNow Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Removes entries from the change log for the specified workbook.

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.

This example removes all changes that are more than one day old from the change log for the active workbook.

ActiveWorkbook.PurgeChangeHistoryNow Days:=1
Show: