VBA & Macro Problems

Fix a Word for Mac Macro That Does Not Change Font Color

Anum MushtaqAnum Mushtaq Nov 22, 2026 868 views

Question details

The user needs a recorded Word for Mac macro to change the color of selected text along with its other formatting.

Fix a Word for Mac Macro That Does Not Change Font Color
Product
Microsoft Word for Mac, version 16.9 with Microsoft 365
Device & OS
Mac
Scenario
A recorded macro applies the Normal style, bullets, and a font-size change to selected text.
Observed behavior
The macro applies the other formatting but does not change the font color, and its recorded code contains no font-color command.
Before you start

Open a copy of the document and select sample text for testing. Make sure you can identify the recorded macro in Word's Macros dialog and only run macros from trusted sources.

Solution 1Recommended

Add a Font Color Assignment to the Recorded Macro

Use this solution when the recorded VBA procedure contains no command to change the selected text's color.

1
Open the macro editor

In Word for Mac, choose Tools > Macro > Macros, select the recorded macro, and click Edit.

2
Add the color command

In the VBA procedure, add `Selection.Font.Color = wdColorPurple` on its own line after the other formatting commands and before `End Sub`. Replace `wdColorPurple` with another Word color constant if needed.

3
Test the updated macro

Return to the document, select sample text, and run the macro through Tools > Macro > Macros or its assigned shortcut. Check that the text color and other formatting are applied.

4
Update and test another file

If the color still does not change, choose Help > Check for Updates in Word and install available Office updates. If Word was installed through the Mac App Store, check for updates there. Then test the macro on selected text in another document.

Add a Font Color Assignment to the Recorded Macro
Check the selection: The assignment changes the font color of the current selection. Select the intended text before running the macro.
Free Microsoft Office alternative

Format Document Text with WPS Writer

WPS Office is a free, lightweight alternative with a familiar interface for editing and formatting documents. Its Microsoft Word format support makes it easy to move documents between suites, although it does not fix Word for Mac VBA issues.

Change text color using familiar font-formatting controlsOpen and edit Microsoft Word DOC and DOCX documentsMove to a familiar interface without a steep learning curveUse a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does my recorded macro change the font size but not the color?

The recorder may have omitted the color command. Open Tools > Macro > Macros, select the macro, and click Edit to check whether its VBA procedure includes a font-color assignment.

Where should I put the font color line in the macro?

Add `Selection.Font.Color = wdColorPurple` inside the procedure, after the other formatting commands and before `End Sub`. This helps prevent a later formatting command from overriding the color.

How can I tell whether the problem is specific to one document?

Open another document, select some text, and run the edited macro from Tools > Macro > Macros. If it works there, investigate formatting or other differences in the original document.

What should I do if the edited macro still does not change the color?

Confirm that the intended text is selected and that no later macro command changes its formatting. Update Office through Help > Check for Updates or the Mac App Store, then test again in another document.