View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RobinK RobinK is offline
external usenet poster
 
Posts: 2
Default 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!