Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Customize Header From Cell Value
Is there a way to have the header of a workbook come from a value in a cell?
I have a template and would like to have the user type in what their project name is in cell A1 and then have the Header become the value that they typed. TIA! |
#2
|
|||
|
|||
Jenn
Private Sub Workbook_BeforePrint(Cancel As Boolean) With ActiveSheet .PageSetup.CenterFooter = .Range("A1").text End With End Sub This is workbook event code. With the workbook open and maximized, right-click on the Excel logo left of "File" on menu bar. Select "View Code". Paste the above code in that module. Note: only the active sheet will have that header. Gord Dibben Excel MVP On Mon, 29 Aug 2005 15:26:06 -0700, "Jenn" wrote: Is there a way to have the header of a workbook come from a value in a cell? I have a template and would like to have the user type in what their project name is in cell A1 and then have the Header become the value that they typed. TIA! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell reference in header row | Excel Discussion (Misc queries) | |||
excel - insert cell contents in a custom header / footer | Excel Discussion (Misc queries) | |||
Modify many row cell (header) to one column | Excel Discussion (Misc queries) | |||
can I customize cell fill patterns in Excel? | Excel Discussion (Misc queries) | |||
Same Cell Header For Every Page | Excel Discussion (Misc queries) |