I have a VBA macro that inserts a cell value into my header. What I would like to do is change the format of the inserted information (make it BOLD, change font size, etc.).
The line of code I have is this....
Thank you in advance for your time.
Chuck
Re: Formatting Header From Macro
Try recording amacro while you set the formattngthat you desire here what I just recorded. Look like all you may need is the .CenterHeader line.
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = "&""Book Antiqua,Bold""&12Test"
.RightHeader = ""
.LeftFooter = ""
.CenterFooter = ""
.RightFooter = ""
.LeftMargin = Application.InchesToPoints(0.75)
.RightMargin = Application.InchesToPoints(0.75)
.TopMargin = Application.InchesToPoints(1)
.BottomMargin = Application.InchesToPoints(1)
.HeaderMargin = Application.InchesToPoints(0.5)
.FooterMargin = Application.InchesToPoints(0.5)
.PrintHeadings = False
.PrintGridlines = False
.PrintComments = xlPrintNoComments
.PrintQuality = 600
.CenterHorizontally = False
.CenterVertically = False
.Orientation = xlPortrait
.Draft = False
.PaperSize = xlPaperLetter
.FirstPageNumber = xlAutomatic
.Order = xlDownThenOver
.BlackAndWhite = False
.Zoom = 100
.PrintErrors = xlPrintErrorsDisplayed
End WithRe: Formatting Header From Macro
Tom and Ross,
That is what I needed and it worked like a charm!
Thanks to both of you for taking the time to help.
Chuck
Re: [Solved] Formatting Header From Macro
Forgot to add that this is solved, sorry.
Don’t have an account yet? Register yourself now and be a part of our community!