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.

formatting headers/footers
 

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.

formatting headers/footers
 

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.