Hello,
My friend helped me create a customized header using this VB code, I'm
not sure how to make them font size 12 and bold. Could someone please
help?

Regards,
SV

Try recording a macro when you change the header--include changing the font size
and bolding--and you'll see the code.

SV wrote:

Hello,
My friend helped me create a customized header using this VB code, I'm
not sure how to make them font size 12 and bold. Could someone please
help?

Regards,
SV

--

Dave Peterson

Example code.

Sub Header_Custom()
With ActiveSheet.PageSetup
.LeftHeader = "&""Algerian,Bold""&16hoohah"
End With
End Sub


Gord Dibben MS Excel MVP

On Thu, 18 Oct 2007 13:54:25 -0000, SV wrote:

Hello,
My friend helped me create a customized header using this VB code, I'm
not sure how to make them font size 12 and bold. Could someone please
help?

Regards,
SV