I recorded a macro but it did not show it when print preview or when
printing.
To explane the idea more:
If I go to the page setup menu, header & Footer and add the custom
header i want, it stays there and can be seen when printing it.
Sub Add_Header_Footer()
With ActiveSheet.PageSetup
.LeftHeader = "My Left Header"
.CenterHeader = "My Center Header"
.RightHeader = "My Right Header"
.LeftFooter = "My Left Header"
.CenterFooter = "My Center Footer"
.RightFooter = "My Right Footer"
End With
End Sub
Thanks Dave,
I am almost there.
My left header is a picture (\stone\L_Logo.tif) and is in the same
folder as the Excel file.
I did not succeed to have the picture shown!
How can it be done? What should I put after the equal sign in
the .LeftHeader line?
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.