How to save font color to use in a VBA macro
I am trying to automate the changing of the font color instead of selecting and then applying the font color from the ribbon.
I'm hoping that I can do this in a macro. I know how to select what I need to change. The problem I have is applying the font color as this will be in a template, so the color can change from document to document based on this template. The color of the whole document is black, but there are several times through out the document were I need to change the font color of certain words or phrases.
Is there a way to either get whatever the color of the font button on the ribbon is or to set this color, which usually would be a custom color, to a variable which I then could apply using with selection.font?
|