Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-28-2023, 09:40 PM
elaineAda elaineAda is offline Macro to switch all text color in a document Windows XP Macro to switch all text color in a document Office 2010
Novice
Macro to switch all text color in a document
 
Join Date: Mar 2019
Posts: 25
elaineAda is on a distinguished road
Default Macro to switch all text color in a document

Hi Hi
I need help to write a macro to switch the following text color:

In a document, there are text with many different font color:


One macro (macro1) to
switch all text to white font color

Another macro (macro2) to

Reverse (macro1) to the original font color, can be red, black etc.


Thanks thanks.

Last edited by elaineAda; 01-29-2023 at 03:04 AM.
Reply With Quote
  #2  
Old 01-29-2023, 03:34 PM
Guessed's Avatar
Guessed Guessed is offline Macro to switch all text color in a document Windows 10 Macro to switch all text color in a document Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,969
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

This is actually surprisingly complicated as there are 256x256x256 possible colours and lots of places that colour could be applied (inline text, text boxes, comments, footnotes, headers, footers, smart art, tables, paragraph shading etc)

The first macro would be simpler but it would likely remove any 'differences' that would be required for the second macro to restore the original colours.

If your documents were well structured and either used theme palette colours OR character styles to set the colours then you might get the desired result but that is kind of unlikely.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to switch all text color in a document How to Extract from document all text that has a shade color? poetofpiano Word VBA 2 03-14-2022 08:43 AM
Power point Macro for random symbols/text/color jodyto PowerPoint 0 10-09-2019 01:39 AM
Macro to switch all text color in a document Text Field [content control] - Default text color vs Filled Text color jackcoletti Word 3 02-01-2017 08:10 AM
Macro to switch all text color in a document Macro to color row of Word table based on found text kristib Word VBA 4 11-15-2015 02:42 PM
Macro to switch all text color in a document Macro to search warning text style and replace the text color rohanrohith Word VBA 3 11-27-2014 01:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:28 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft