Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Make Page header bold.

Status
Not open for further replies.

cassidybklyn

Programmer
Apr 23, 2007
82
US
Good morning Skip,
I am trying to make my page header bold. How can I get this done?

With ActiveSheet.PageSetup
.CenterHeader = " Class of 2007".
End with.

How can I make the "Class of 2007" bold?
Thanks.
Cassidy.

 
Cassidy:

FYI, all contributors here are volunteers. We all have real jobs (not working for Tek-Tips) and donate time here when we can. For that reason, you should not address your questions to a single member. There are other members who can also help, and Skip might be busy right now and not checking the site.

To answer your question: turn on your macro recorder (Tools > Macro > Record new macro), do what you want to do to the header, and observe the recorded code.

That's it!

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.
 
Thanks John.
Your comment is quite understood. Pardon me gentlemen.
Thanks.
Cassidy.
 
No problem at all, Cassidy. I just saw you were new here (welcome aboard, BTW) and wanted to make sure you understood how things work.

Actually, given Skip's penchant for answering questions very quickly, it is usually safe to assume that he's logged in and waiting to pounce a any new questions. [wink]

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top