Document Editing Problems

Accept Word Tracked Changes Before a Specific Date

Amos GikundaAmos Gikunda Nov 18, 2026 869 views

Question details

Accept tracked changes in a Word document based on when they were created.

Accept Word Tracked Changes Before a Specific Date
Product
Microsoft Word
Device & OS
not provided
Scenario
A user wants to accept revisions made before a specified date while leaving later revisions for review.
Observed behavior
Word does not provide a standard command to accept tracked changes by both author and date.
Before you start

Open the document in a desktop version of Word that supports VBA, and use File > Save As to create a separate copy. Check your system's date format so you can enter the cutoff date in a format Word recognizes.

Solution 1Recommended

Use a VBA macro to accept revisions before a cutoff date

Use this method to accept revisions dated before a selected day while retaining changes from that day and later.

The macro checks each revision's Date property and accepts matching revisions in reverse order. It compares date values rather than formatted date strings.

1
Open the VBA editor

With the document copy open in Word, press Alt+F11 to open the Visual Basic editor.

2
Add the macro

In the VBA editor, choose Insert > Module and paste this code: Sub AcceptChangesBeforeDate() Dim i As Long Dim acceptedCount As Long Dim dateInput As String Dim cutoff As Date dateInput = InputBox("Enter the cutoff date in your system's date format:", "Accept Changes Before Date") If dateInput = "" Then Exit Sub If Not IsDate(dateInput) Then MsgBox "Enter a valid date and run the macro again." Exit Sub End If cutoff = DateValue(dateInput) For i = ActiveDocument.Revisions.Count To 1 Step -1 If ActiveDocument.Revisions(i).Date < cutoff Then ActiveDocument.Revisions(i).Accept acceptedCount = acceptedCount + 1 End If Next i MsgBox "Accepted " & acceptedCount & " changes." End Sub

3
Run the macro

Return to Word, press Alt+F8, select AcceptChangesBeforeDate, and click Run. Enter the cutoff date when prompted.

4
Review the result

Open the Review tab and inspect the remaining tracked changes before saving the document copy.

Use a VBA macro to accept revisions before a cutoff date
Include the selected date: To accept changes made at any time on the selected date as well, replace `cutoff = DateValue(dateInput)` with `cutoff = DateAdd("d", 1, DateValue(dateInput))`. The comparison remains `< cutoff`.
Free Microsoft Office alternative

Review Word Documents in WPS Writer

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Word documents. It can help you continue working with compatible files, but it does not run this Word macro as a guaranteed fix.

Review and edit documents in WPS WriterCompatible with Microsoft Word DOC and DOCX formatsFamiliar interface for a smoother move from Microsoft OfficeFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Does the macro accept changes made on the cutoff date?

No. The default comparison accepts revisions before midnight at the start of the selected date. To include the whole date, set cutoff to DateAdd("d", 1, DateValue(dateInput)) and keep the `< cutoff` comparison.

Can I limit the macro to one author's changes?

Yes. In the VBA editor, add an author check to the If condition, such as `And ActiveDocument.Revisions(i).Author = "Author Name"`. Use the author name recorded on the revisions.

What if Word does not recognize the date I enter?

Run the macro again from Alt+F8 and enter the date in the format recognized by your system. The macro exits without accepting changes if IsDate cannot interpret the entry.

Can I undo the accepted changes after saving?

Accepted revisions may not be easy to restore after saving. Use File > Save As to work on a separate copy before running the macro, and review the result before saving it.