You can't change the background color of a header or footer.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Elena" wrote in message
...
I have a code to sent a center header that works perfectly:

MyWs.PageSetup.CenterHeader = "Worksheet 1"

I would like to set the background of that header to a color.
Is that
possible?

Thanks in Advance,
Elena