ExcelBanter - Custom Page Headers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Custom Page Headers (https://www.excelbanter.com/excel-discussion-misc-queries/3690-custom-page-headers.html)

jamess@therock

Custom Page Headers

I want to show the contents of a cell in the page header when I print the
document. Does anyone have a solution for this?

Jason Morin

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.CenterHeader = ActiveSheet _
..Range("A1").Value
End Sub

---
Place this macro in the "ThisWorkbook" module.

HTH
Jason
Atlanta, GA

-----Original Message-----
I want to show the contents of a cell in the page header
when I print the
document. Does anyone have a solution for this?
.

All times are GMT +1. The time now is 11:14 PM.