Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-08-2020, 12:55 PM
Gilvv Gilvv is offline Trying to hide only colored characters on my files Windows 7 64bit Trying to hide only colored characters on my files Office 2010 64bit
Advanced Beginner
Trying to hide only colored characters on my files
 
Join Date: Oct 2016
Posts: 30
Gilvv is on a distinguished road
Default Trying to hide only colored characters on my files

Hello,



I have many files with both colored (many different colors) and black (automatic) text and I want to replace to “hidden” all colored characters. It seems simple enough but, beyond being new to VBA, I just can’t get it to work. I’m using

If (.Color <> wdColorAutomatic) And _
(.Color <> wdColorBlack) Then

In my code. It seems to be a feasible way to go but. . .

Any help and/or advice would be greatly appreciated.

Thank you in advance.
Reply With Quote
  #2  
Old 03-08-2020, 02:39 PM
macropod's Avatar
macropod macropod is offline Trying to hide only colored characters on my files Windows 7 64bit Trying to hide only colored characters on my files Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The simplest way to go about this in a multi-colour document is to first hide all text, then use Find/Replace to unhide just the colour(s) you're interested in. If there's more than one colour to unhide, you'd do them sequentially.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 03-08-2020, 02:46 PM
Gilvv Gilvv is offline Trying to hide only colored characters on my files Windows 7 64bit Trying to hide only colored characters on my files Office 2010 64bit
Advanced Beginner
Trying to hide only colored characters on my files
 
Join Date: Oct 2016
Posts: 30
Gilvv is on a distinguished road
Default

Thank you, Macropod!

I'll try that and will let you know.

Best regards.
Reply With Quote
  #4  
Old 03-08-2020, 02:52 PM
Gilvv Gilvv is offline Trying to hide only colored characters on my files Windows 7 64bit Trying to hide only colored characters on my files Office 2010 64bit
Advanced Beginner
Trying to hide only colored characters on my files
 
Join Date: Oct 2016
Posts: 30
Gilvv is on a distinguished road
Default

Indeed, it worked like a charm!

Thanks again, Macropod; your help is much appreciated!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Strange Characters appear when selecting SHOW ALL NON PRINTING CHARACTERS ann Amber Word 1 08-01-2015 08:06 PM
How to Hide/Un-hide a worksheet based on cell on another sheet. easton11 Excel Programming 1 06-02-2015 12:07 PM
How to hide text in the plus symbol "+", like in *.chm files Alexis Word 4 06-02-2013 12:04 PM
Trying to hide only colored characters on my files colored background to text userman Word 2 09-26-2012 01:52 AM
Junk characters (box-like characters) in Word file Sashikala Word 1 04-20-2010 02:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04: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