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