Header Font

J

jesmin

Hi:
Happy new year. I have created an Excel report. In its center header
put a text. Now how can I change the font size of this text in cente
header to 12.
I am bolding the text at the same time. I tried in VBA something like:

dim mystr = "Monthly Report"
With Activesheet
.pagesetup.centerheader = "&B" & mystr
..........code to change font

End with

Thanks in advanc
 
W

wjohnson

Go to Menu - Select FILE - PAGE SETUP - CUSTOM HEADER - type in what you
want. There should be some icons directly above the "LEFT - RIGHT -
CENTER" section boxes - select your text then select the "A" icon and
follow the directions.
 
Top