VBA change font color to background color

macropod · #6 05-31-2018, 04:36 PM

Quote:

Originally Posted by donaldadams1951

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.

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
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