MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Color footers


Posted by Marvin on October 30, 2001 12:54 PM

Is there a way to print headers and/or footers in color in Excel 2000. I searched the MS Knowledgebase and the article returned (Q214097) stated that this feature is not available in versions of Excel later than 3.0. It also stated there is currently no code available to perform this task. Is this accurate? I'll refrain from stating any opinion on this &%*#&)(* improvement however, why is they always seem to find a way to leave out really useful features like this? I'm relying on the fact there is some Excel guru out there with the smarts to outsmart the men of Redmond. Any takers?


Posted by Damon Ostrander on October 31, 2001 11:56 AM

Hi Marvin,

I hate to be the bearer of bad news, but I don't think this can be done, at least not without a custom dll that replaces Microsoft's header/footer code. Microsoft has published nothing in the Excel object model that gives the header/footer text color properties.

I think you will have to fall back on creating your own header/footer by putting it into rows on the worksheet, or textboxes on the chart sheets. These things could be automated with VBA code to put the header/footer rows in the correct places relative to the page breaks so that they always fall at the top and bottom of each page. This would not only enable the use of color, but also color graphics, which Excel headers/footers also don't support. Obviously, color must be very important before this option becomes attractive.

I hope this helps.

Damon