Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-28-2018, 01:04 PM
donaldadams1951 donaldadams1951 is offline VBA change font color to background color Windows XP VBA change font color to background color Office 2010 32bit
Advanced Beginner
VBA change font color to background color
 
Join Date: Dec 2013
Location: San Francisco Bay Area
Posts: 37
donaldadams1951 is on a distinguished road
Default VBA change font color to background color

I have a line of text in a document that is the title of a protected section. The section is protected so the end user can't edit the text in that section but they need to be able to delete the section. They delete the protected section by clicking a button on the ribbon. The macro finds the section by looking for the title and deletes the section if requested.



Since the end user does not want to see the title and I use the title as a "marker" I want to leave the title there but make it disappear. I tried to handle it by hiding the text but it works inconsistently. The next idea I came up with is to make the title font color the same as the background so it "disappears". Is there a VBA way make the text font color the same as the background? That way it would be there but not visible to the end user.
The text should also be invisible during printing.

If there is a better way to do this please let me know. Thanks
Reply With Quote
 

Tags
background color, font color



Similar Threads
Thread Thread Starter Forum Replies Last Post
Change excel background color, strange... sojiro Excel 7 04-18-2018 10:07 AM
Style Font Color: Background 1 gmgj Word 3 12-20-2017 04:00 PM
Advanced Font Color Manipulation In Word: Inserting another color than the surrounding text stuartg Word 1 02-20-2017 12:38 AM
VBA change font color to background color Remove white text background (keeping the font color and page color intact cc3125 Word 1 10-26-2015 06:44 PM
Font Color Question//.Replacement.Font.Color = 12611584 rsrasc Word VBA 3 09-05-2015 09:03 PM

Other Forums: Access Forums

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