PDA

View Full Version : macro that changes white text in black text



robzane
02-13-2022, 09:42 AM
Is there a macro that searches white text in tables in a document and replaces wihte text in black text?
Or is there something like it to modify?
Thank You

Chas Kenyon
02-13-2022, 03:47 PM
You could use the Replace feature. No macro needed. However, you may, instead, want automatic color instead of black or white.

robzane
02-14-2022, 02:24 AM
You could use the Replace feature. No macro needed. However, you may, instead, want automatic color instead of black or white.

Replace command does not see white text

Chas Kenyon
02-14-2022, 05:30 PM
Replace command does not see white text

Yes, it does. If the font is white, that can be picked up. If Replace can't pick it up, neither can vba.
Again, consider changing everything to Automatic.

If you want, save a short sample document with the problem and post a link to it. Here's how to do that.
Why a sample file is important for troubleshooting. How to do it. (https://answers.microsoft.com/en-us/msoffice/forum/msoffice_word-mso_win10-mso_365hp/why-a-sample-file-is-important-for-troubleshooting/9441ae3c-1e92-41c6-9a1f-5b377b08e5a5?tm=1619027698258)

robzane
02-15-2022, 12:59 AM
Yes, it does. If the font is white, that can be picked up. If Replace can't pick it up, neither can vba.
Again, consider changing everything to Automatic.

If you want, save a short sample document with the problem and post a link to it. Here's how to do that.
Why a sample file is important for troubleshooting. How to do it. (https://answers.microsoft.com/en-us/msoffice/forum/msoffice_word-mso_win10-mso_365hp/why-a-sample-file-is-important-for-troubleshooting/9441ae3c-1e92-41c6-9a1f-5b377b08e5a5?tm=1619027698258)

I do not know words in white so I can't use replace

I can't understand how to use automatic

Thank You

Chas Kenyon
02-15-2022, 04:16 PM
Automatic is a color choice. It is black if the background is light, and white if the background is dark.
You do not need to know the words, just the color.
29412
You get the color by clicking on More and then under Format picking Font.

robzane
02-16-2022, 12:41 AM
Automatic is a color choice. It is black if the background is light, and white if the background is dark.
You do not need to know the words, just the color.
29412
You get the color by clicking on More and then under Format picking Font.

Thank You