Header

  • Thread starter Thread starter SV
  • Start date Start date
S

SV

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.
 
Example code.

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorry forgot the vb code for the header! 2
Font in Header - @22 "25 Miles" goes to 409 font 1
Format Center Header 1
Word Macro to insert text and save as PDF 4
Custom Header 1
Formating and Header coloring in VB script for summary sheet 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Headers and Footers by VBA? 6

Back
Top