ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Header (https://www.excelbanter.com/excel-programming/399559-header.html)

SV[_3_]

Header
 
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

Header
 
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

Gord Dibben

Header
 
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




All times are GMT +1. The time now is 05:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com