View Single Post
 
Old 05-28-2018, 01:04 PM
donaldadams1951 donaldadams1951 is offline Windows XP Office 2010 32bit
Advanced Beginner
 
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