Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-20-2017, 03:43 PM
AXbean AXbean is offline Change color of hidden characters Windows 10 Change color of hidden characters Office 2013
Novice
Change color of hidden characters
 
Join Date: Feb 2017
Posts: 5
AXbean is on a distinguished road
Default Change color of hidden characters

Hi Folks, me again. I want to create a macro in Word that will search a document and change all of the hidden characters (that are, at this point, unhidden), and change their font color. Can you point me to some code that will hel?



Thanks,
Robert
Reply With Quote
  #2  
Old 02-20-2017, 05:20 PM
macropod's Avatar
macropod macropod is offline Change color of hidden characters Windows 7 64bit Change color of hidden characters Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,373
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

Switch on the macro recorder and record using Find/Replace to do that. The code thus produced is nearly as efficient as hand-written code.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 02-20-2017, 05:42 PM
AXbean AXbean is offline Change color of hidden characters Windows 10 Change color of hidden characters Office 2013
Novice
Change color of hidden characters
 
Join Date: Feb 2017
Posts: 5
AXbean is on a distinguished road
Default

Thanks Paul, I did think of that. I thought maybe there was a way to get around coding to find and replace paragraph marks, then spaces, then tabs, etc. If not, that's cool, I can set up a macro from recorder.
Reply With Quote
  #4  
Old 02-20-2017, 05:40 PM
macropod's Avatar
macropod macropod is offline Change color of hidden characters Windows 7 64bit Change color of hidden characters Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,373
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

Cross-posted at: https://www.mrexcel.com/forum/genera...haracters.html

For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 02-20-2017, 05:57 PM
macropod's Avatar
macropod macropod is offline Change color of hidden characters Windows 7 64bit Change color of hidden characters Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,373
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

All of that really comes down to what you specify for your Find/Replace. Besides which, it would have been a waste of anyone else's time writing a macro based on your initial specifications only to now find that what you really want is somewhat different.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
I can't change the highlighter color ralfph OneNote 0 10-22-2016 08:01 AM
Change color of hidden characters VBA: How to change color of a CommandButton dh1sbg PowerPoint 2 09-27-2016 12:44 AM
Change color of hidden characters Formula for tracking (shipping) numbers when number of characters change howie707 Excel 3 08-26-2015 05:32 AM
Change color of hidden characters Color words ending with special characters Singh_Edm Word 2 01-20-2014 12:51 AM
color change for same shape ajkiran PowerPoint 1 11-10-2012 07:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:41 AM.


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