| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why would page 1 of an excel worksheet print smaller of page 2 if. | Excel Discussion (Misc queries) | |||
| Hidden page bracks in Excel should be deactivated | Excel Discussion (Misc queries) | |||
| How do I freeze or lock cells to show up on each page without typ. | Excel Discussion (Misc queries) | |||
| Page breaks don't show on screen and don't print separately. It i. | Excel Discussion (Misc queries) | |||
| how to print a row on the bottom of every page | Excel Discussion (Misc queries) | |||
Linear Mode
