View Single Post
 
Old 03-03-2017, 03:54 PM
GAmanda GAmanda is offline Windows 10 Office 2016
Novice
 
Join Date: Mar 2017
Posts: 1
GAmanda is on a distinguished road
Default 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?
Reply With Quote