LinkBack URL
About LinkBacks
HerryMarkowitz 
Hi friends,
1- Open enclosed file.
2- Run Macro1.
3- Run Macro2.
4- Look printing view of page. (See "My Heading" font size is 8.)
So, I need a macro like this;
Regards
ActiveSheet.PageSetup.CenterHeader = "My Heading".Font.Size = 16
Hi friends,
1- Open enclosed file.
2- Run Macro1.
3- Run Macro2.
4- Look printing view of page. (See "My Heading" font size is 8.)
So, I need a macro like this;
RegardsActiveSheet.PageSetup.CenterHeader = "My Heading".Font.Size = 16
Sub DontForgetThese() If Your thread includes any code Then Please use code tags... If Your thread has been solved Then Please mark as solved... If Anybody has helped to you Then Please add reputation... End Sub
[code]
ActiveSheet.PageSetup.CenterHeader = "&16My Heading"
[\code]
search help for "Formatting Codes For Headers And Footers" for more details on available codes.
Hi Andy,
Thanks for the answer. Solved.
I have one more question.
I found following links.
http://msdn.microsoft.com/en-us/libr...ffice.12).aspx
http://msdn.microsoft.com/en-us/libr...(v=vs.90).aspx
How can I change font color ?
ActiveSheet.PageSetup.CenterHeader = "&16&H&KFF0000Red &H&K00FF00Green &H&K0000FFBlue"
Perfect.
KFF0000--->Red
K00FF00--->Green
K0000FF--->Blue
Do you have a link which I can check other colours ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks