HELP!!!

A

Angel Martinez

OK I am workin in Excel 2007 and I have a macro that will create an email for you with all the data I need. I am also adding text to the body of this email. 2 lines of text that I am adding I want to change the Font color and also Highlight it yellow. I can get it to change the Font color but I cannot get it to highlight the text. I have tried the following lines of code and nothin

objSel.BackgroundPatternColor = wdColorYellow
objSel.Font.ColorIndex = wdColorYellow
objSel.Font.Highlight = 65535
objsel.Interior.Color = wdColorYellow

Is there something I am missing. Or a different line I can use to Highlightthe text I want? Please help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select text of a particular shading color (VBA macro) 5
Need help modifying code 0
How to insert HTML into an Outlook 2021 email 0
Converting URLs in comments to Markdown-formatted links 2
Outlook 365 overriding formatting choices 0
Problem with MS Word paragraph and character styles: format getting messed up 2
How can the font and size of (all) citation numbers be altered? 1
Font drop-down menu very slow 0

Top