HEADER FONT COLOUR

Hi, is it possible to change the font colour in a
header? If so, how can it be done?? Cheers, Toni

Toni, I don't think that you can change the font color in the header, but
you can use the first row as the header, have a look here for more details
http://www.geocities.com/davemcritch...el/logoshd.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
"Toni" wrote in message
...
Hi, is it possible to change the font colour in a
header? If so, how can it be done?? Cheers, Toni

Yes, but you will have to do it with a VB code like this one:

Rows(1).Font.ColorIndex=5

I don't know the color index codes but the other might be
of extra help on this one.

Toni, for whatever it may be worth, if you search the topic "Change the font
in header and footer text" in Excel 2003, it says "You cannot change the
color of header and footer text."

On his Website, Chip Pearson has some VBA code for headers and footers. It's
he http://www.cpearson.com/excel/headfoot.htm.. Note that while his code
covers changing fonts, font attributes, and font sizes, he makes no
mention -- and this is significant, I think --of changing font colors.

So I suppose the long and the short of it is that it can't be done. That
being so, I think Paul B's suggestion is the way to go.
--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com


"Toni" wrote in message
...
Hi, is it possible to change the font colour in a
header? If so, how can it be done?? Cheers, Toni

Hi Paul,
Like Henry Ford -- any color you want as long as it is black.
My website has moved (at least what gets updated) so the
page actually is
Logos and Graphics into headers/footers
http://www.mvps.org/dmcritchie/excel/logoshd.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

David, thanks for the updated link


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
"David McRitchie" wrote in message
...
Hi Paul,
Like Henry Ford -- any color you want as long as it is black.
My website has moved (at least what gets updated) so the
page actually is
Logos and Graphics into headers/footers
http://www.mvps.org/dmcritchie/excel/logoshd.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm