VBA to set colour of header or footer text?

[Phil Smith]

Is it possible to use VBA to change the colour of text in the header or footer of an Excel worksheet, and if so, what is the correct syntax?

I have looked around on the internet and come up with &Kcolour, where colour is a hexadecimal value, then converted my RGB values to hexadecimal, but my text is stubbornly staying at black.

Any takers?

Phil

 

[Phil Smith]

Got it!

After some more head scratching I found out that the &Kcolour needs to go after any other formatting and IMMEDIATELY before the text that is to have it's colour changed.

I ended up with:

.CenterHeader = "&C&50&""Arial""&K00007DText to be formatted"

which turns my text into a darkish shade of blue.

I was originally trying with:

.CenterHeader = "&K00007D&c&50&""Arial""Text to be formatted"

whcih did NOT work.

So problem solved!