I have the following code in my VBA macro but it doesn't seem to work. I'd like the "Exclude This MLS" button to be highlighted with a Yellow background. Please advise what I am doing wrong. Thanks.
Options.DefaultHighlightColorIndex = wdYellow
Selection.TypeText Text:="MacroButton ExcludeThisMLS Exclude This MLS"
Selection.Range.HighlightColorIndex = wdYellow
Selection.Fields.Update
Options.DefaultHighlightColorIndex = wdYellow
Selection.TypeText Text:="MacroButton ExcludeThisMLS Exclude This MLS"
Selection.Range.HighlightColorIndex = wdYellow
Selection.Fields.Update