Change text color

W

Wynn

I have a blue that I have to change throughout several documents to a
specific blue with RGB colors values. Is there a way to do this through VBA?
 
E

Ed

Try looking into using the Color property, as in
Selection.Font.Color = RGB(255, 0, 0)
Ed

Wynn said:
I have a blue that I have to change throughout several documents to a
specific blue with RGB colors values. Is there a way to do this through
VBA?
 
W

Wynn

Thanks Ed. This is the macro that I created (in this case to also change a
red color)

Sub BlueColorChange()
'
' Macro to change standard blues to specific gradients
Selection.WholeStory
If Selection.Font.Color = RGB(0, 0, 128) Or Selection.Font.Color =
RGB(255, 0, 0) Then
Selection.Font.Color = RGB(0, 45, 98)
End If
End Sub

"Ed" escribió:
 

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

Top