Thread: formatting headers/footers

Where can I find documentation on formatting headers and footers? I've found
an example that sets the font and size, but haven't been able to figure out
how to set bold and/or italics and do a line feed.

The best way is to turn the Macro Recorder 'On' and set the Header, then
study the generated code.

Eg: I wrote in the header:
this time i
what do you
on two line with the part 'i what' in bold arail 11pt
also i inserted a new line after the 'i' --> chr(10)
Here is the generated code:
ActiveSheet.PageSetup.LeftHeader = _
"this &""Arial,Bold""&11time i" & Chr(10) & "what &""Arial,Regular""do
you"
--
Regards,
Sébastien
<http://www.ondemandanalysis.com>


"lallen" wrote:

> Where can I find documentation on formatting headers and footers? I've found
> an example that sets the font and size, but haven't been able to figure out
> how to set bold and/or italics and do a line feed.

Thanks Sebastien. Excellent suggestion. It worked like a charm.

Larry

"sebastienm" wrote:

> The best way is to turn the Macro Recorder 'On' and set the Header, then
> study the generated code.
>
> Eg: I wrote in the header:
> this time i
> what do you
> on two line with the part 'i what' in bold arail 11pt
> also i inserted a new line after the 'i' --> chr(10)
> Here is the generated code:
> ActiveSheet.PageSetup.LeftHeader = _
> "this &""Arial,Bold""&11time i" & Chr(10) & "what &""Arial,Regular""do
> you"
> --
> Regards,
> Sébastien
> <http://www.ondemandanalysis.com>
>
>
> "lallen" wrote:
>
> > Where can I find documentation on formatting headers and footers? I've found
> > an example that sets the font and size, but haven't been able to figure out
> > how to set bold and/or italics and do a line feed.