Only change left header on all worksheets
Good Morning!
I'm using Excel 2003. I've created a macro that changes my left header only
on all worksheets. This works great except on the first worksheet, the
header point varies on all sheets.
Is there a way to change the header and keep the original point size? When
I run the macro, it changes all headers to 10 pt, which is the default point
size.
Here's my macro:
Sub SetHeader()
For Each ws In Worksheets
ws.PageSetup.LeftHeader = "My Document, Rev. 4, Volume 2" & Chr(10) & _
"&""Arial,Italic""My Document Title"
Next
End Sub
Thanks in advance!
|