Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can you reference cell values in Headers and Footers in Excel 200.
I want to customize my Header on an Excel spreadsheet to include the value
conatined in certain cells on my worksheet such that I will not have to change the header every time I change the value of the referenced cell. Does anyone know how to do this? |
#2
|
|||
|
|||
Hi
only possible with VBA using an event procedure. e.g. put the following code in your workbook module for cell A1 Private Sub Workbook_BeforePrint(Cancel As Boolean) Dim wkSht As Worksheet For Each wkSht In Me.Worksheets With wkSht.PageSetup .CenterFooter = wksht.range("A1").value End With Next wkSht End Sub -- Regards Frank Kabel Frankfurt, Germany "jkyte" schrieb im Newsbeitrag ... I want to customize my Header on an Excel spreadsheet to include the value conatined in certain cells on my worksheet such that I will not have to change the header every time I change the value of the referenced cell. Does anyone know how to do this? |
#3
|
|||
|
|||
Thanks
"Frank Kabel" wrote: Hi only possible with VBA using an event procedure. e.g. put the following code in your workbook module for cell A1 Private Sub Workbook_BeforePrint(Cancel As Boolean) Dim wkSht As Worksheet For Each wkSht In Me.Worksheets With wkSht.PageSetup .CenterFooter = wksht.range("A1").value End With Next wkSht End Sub -- Regards Frank Kabel Frankfurt, Germany "jkyte" schrieb im Newsbeitrag ... I want to customize my Header on an Excel spreadsheet to include the value conatined in certain cells on my worksheet such that I will not have to change the header every time I change the value of the referenced cell. Does anyone know how to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Losing my headers and footers when I copy the file | Excel Discussion (Misc queries) | |||
Better support for dynamic content within headers and footers | Excel Discussion (Misc queries) | |||
Headers / footers in Excel | Excel Discussion (Misc queries) |