Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change justification in right Excel header box to left justify. | Excel Discussion (Misc queries) | |||
How to change the right-to-left worksheet to left-to-right workshe | Excel Discussion (Misc queries) | |||
header in right or left margin? | Excel Discussion (Misc queries) | |||
how do I make the left margin of a header the same as the page ma. | Excel Discussion (Misc queries) | |||
Left/Right Margins in Header/Footer | Excel Discussion (Misc queries) |