Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 12-15-2022, 04:01 AM
ChrisGreaves ChrisGreaves is offline VBA Code to turn all text in a document black based on font, size, or other attributes Windows 10 VBA Code to turn all text in a document black based on font, size, or other attributes Office 97-2003
Novice
 
Join Date: Nov 2022
Location: Bonavista, Newfoundland
Posts: 22
ChrisGreaves is on a distinguished road
Default

Quote:
Originally Posted by Keithronaut View Post
... I only want to turn the Calibri 11.5 pt. black while leaving the rest of the font as-is. Thank you so much in advance!
Hello Keith. This was my business back in the 90s for multiple documents from multiple sources.
All "document cleansing" is based on locating specific items and substituting items with (usually) different characteristics, all the way from text, fonts, sequence numbering and WP5.1 document tables (built with those weird graphic characters) with MSWord tables.


I found it expedient to write a single find-and-replace macro and then feed it the input and output characteristics from a table of rules which drove the whole process. I use the same procedure to this day.


If you anticipate repeated use of find-and-replace code to change numerous items and/or characteristics, please let me know and I will make my code available to you.
Cheers, Chris
Reply With Quote
 

Tags
font color



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Code to turn all text in a document black based on font, size, or other attributes Using custom style instead of inserting font attributes manually in VBA code laith93 Word VBA 2 11-07-2021 12:52 AM
Duplicating Ranges and changing Font Attributes CharlieM Word VBA 3 08-10-2021 04:44 AM
VBA Code to turn all text in a document black based on font, size, or other attributes Merging two Word documents: 2nd document not maintaining original font type and font size Swarup Word 31 08-28-2018 06:55 PM
Locking Header/Footer on Document but still be able to edit body text (size, font, bold, etc) Porkie96 Word 1 06-21-2018 01:56 PM
VBA Code to turn all text in a document black based on font, size, or other attributes Character based Search and Replace font size anacond11 Word 2 08-08-2013 08:10 AM

Other Forums: Access Forums

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


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