Headers & Footers

[James Webb]

The headers and footers (leftheader, centerheader, rightfooter, etc) say they accept strings as values - is there anyway to format those values? i.e. if I want the fonts in the headers to be BOLD, and the text in the footers to be 6 points... etc... ?

I can''t seem to locate formatting options for these items.

What about rich text support???

[Administrator]

Hi James,

The string that the header takes is a script that you can use to format the header. Please refer to this documentation for more information on formatting the string

http://support.microsoft.com/?kbid=213618

Example,

mySheet.PageSetup.CenterHeader = @"&""Gothic,bold""Center Header Text";

Please let me know if you have any questions. Thanks.

Best regards,

Stephen.

>The headers and footers (leftheader, centerheader, rightfooter, etc) say they accept strings as values - is there anyway to format those values? i.e. if I want the fonts in the headers to be BOLD, and the text in the footers to be 6 points... etc... ?
>
>I can''t seem to locate formatting options for these items.
>
>What about rich text support???