Make Page header bold.

[cassidybklyn]

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.

 

[PHV]

Have you tried the macrorecorder ?

 

[AnotherHiggins]

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.

 

[cassidybklyn]

Thanks John.
Your comment is quite understood. Pardon me gentlemen.
Thanks.
Cassidy.

 

[AnotherHiggins]

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.

[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.