Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-31-2018, 01:15 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 Leave but hide...


The user does not want to see the title but the title contains unique text that is the "marker" to identify the section that might need to be deleted with a macro. It can't be deleted manually by the user as the text is in a protected section that is read-only. I've not given all the details because I did not want to get into to all the whys and wherefores and just muddy the water when all I wanted was to know how to programmatically get the background color so the font color of the text would be the same and would disappear even if the user changed the background cover.
Reply With Quote
  #2  
Old 05-31-2018, 04:36 PM
macropod's Avatar
macropod macropod is offline VBA change font color to background color Windows 7 64bit VBA change font color to background color Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

Quote:
Originally Posted by donaldadams1951 View Post
The user does not want to see the title but the title contains unique text that is the "marker" to identify the section that might need to be deleted with a macro. It can't be deleted manually by the user as the text is in a protected section that is read-only.
Perhaps you could consider using a Custom Document Property or Document Variable to hold a value that an IF field in the body of the document can use to conditionally display/hide all of the applicable content. That way, there's no "marker" to be concerned with, and no need to worry about font colours, etc. If, for example, you create a Custom Document Property named 'MyProp', you could use a field coded as:
{IF{DOCPROPERTY MyProp}= 1 "Conditional Content to Show"}
The macro you're using to drive the process would then only need something like:
Code:
With ActiveDocument
  .CustomDocumentProperties("MyProp").Value = 0
  .Fields.Update
End With
to hide the content, and:
Code:
With ActiveDocument
  .CustomDocumentProperties("MyProp").Value = 1
  .Fields.Update
End With
to display it again after it's been hidden.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

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 12:52 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