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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.