Thread: Print header change
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default 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.




Reply With QuoteReply With Quote