Word Macro issue: Change text color with track changes record

perdur · #1 11-20-2024, 07:00 AM

Sorry to jump into an old thread, but I tried out this solution and ran into a problem where the Word document is showing "simple" markup for the tracked changes (ie, just a line on the side of the text) even though it's in "All Markup" mode (which should be underlining the edited text). So it looks like this:

unnamed.png

The second and third lines were originally red. As you can see, they've successfully turned black, but they're not underlined the way tracked changes normally work. I've double-checked and confirmed that I'm in "All Markup" mode and not "Simple Markup," and I'm at a loss - does anyone know why the Simple Markup line is showing instead?

Despite my user settings, the computer I'm trying to do this on is running Windows 11 and using Office 365.

Edit: This was meant to be in response to the solution provided by Guessed:

Quote:

Originally Posted by Guessed

The Execute ReplaceAll command doesn't track the formatting change so you need to loop that step.

Code:

Sub Macro1()
  Dim aRng As Range, aRng2 As Range
  ActiveDocument.TrackRevisions = True
  ActiveDocument.TrackFormatting = True
  
  Set aRng = Selection.Range
  Set aRng2 = aRng.Duplicate
  With aRng.Find
    .ClearFormatting
    .Font.Color = wdColorRed
    .Text = ""
    .Replacement.Text = ""
    .Forward = True
    .Wrap = wdFindContinue
    .Format = True
    .MatchCase = False
    .MatchWholeWord = False
    .MatchByte = False
    .MatchWildcards = False
    .MatchSoundsLike = False
    .MatchAllWordForms = False
    Do While .Execute = True
      aRng.Font.ColorIndex = wdBlack
      aRng.End = aRng2.End
    Loop
  End With
End Sub

perdur · #2 01-03-2025, 01:29 PM

Quote:

Originally Posted by perdur

Sorry to jump into an old thread, but I tried out this solution and ran into a problem where the Word document is showing "simple" markup for the tracked changes (ie, just a line on the side of the text) even though it's in "All Markup" mode (which should be underlining the edited text).

Circling back to say that I did find a solution to this that shows the tracked changes as underlined instead of just a line on the side (part of the issue was that Word by default indicates font color changes with a line on the side instead of putting the text in tracked changes): Convert underline/strikethrough to Track Changes - Microsoft: Office | Tek-Tips

The solution from user macropod helped me get the text I wanted in tracked changes, so leaving this here in case anyone else stumbles upon this thread with the same issue!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word 16/19 change font and outside border color (same color) eg is red change to pink	jec1	Word VBA	2	12-04-2019 11:32 PM
Macro to change an RGB table cell shading color to another RGB color	David Matthews	Word VBA	4	05-29-2018 02:45 PM
Macro in Word to track colour of highlighted text	BABZ	Word VBA	1	01-09-2017 10:33 PM
Macro to change all text color to black in all docx files in a selected folder	joewoods	Word VBA	13	05-16-2016 06:29 PM
Word macro doesn't change font color	Spideriffic	Word VBA	8	11-04-2015 03:47 AM