Print header change
 

I am printing a worksheet using

With Sheets("Sheet1)
' Code that messes around with the worksheet
'
'
.PrintOut
End With

How can I change the print header before doing the .PrintOut? Thanks.

Print header change
 

Try something like the following before the PrintOut method:

.PageSetup.CenterHeader = "whatever you want"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Hmmm..." wrote in message
...
I am printing a worksheet using

With Sheets("Sheet1)
' Code that messes around with the worksheet
'
'
.PrintOut
End With

How can I change the print header before doing the .PrintOut?
Thanks.

Print header change
 

Hi,
You'll see how to set up all aspects of headers by recording a macro while
you do manual manipulations with page setup. Try pasting a logo too while
you are at that. :)
hth
Paul
U¿ytkownik "Chip Pearson" napisa³ w wiadomo¶ci
...
Try something like the following before the PrintOut method:

.PageSetup.CenterHeader = "whatever you want"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Hmmm..." wrote in message
...
I am printing a worksheet using

With Sheets("Sheet1)
' Code that messes around with the worksheet
'
'
.PrintOut
End With

How can I change the print header before doing the .PrintOut?
Thanks.

Print header change
 

btw:
if you do several changes to page setup, try disabling screen repainting by
Application.ScreenUpdating = False (and then back to True :)
Page setup tends to make screen flicker.
hth
Paul
U¿ytkownik "Chip Pearson" napisa³ w wiadomo¶ci
...
Try something like the following before the PrintOut method:

.PageSetup.CenterHeader = "whatever you want"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Hmmm..." wrote in message
...
I am printing a worksheet using

With Sheets("Sheet1)
' Code that messes around with the worksheet
'
'
.PrintOut
End With

How can I change the print header before doing the .PrintOut?
Thanks.