insert cell contents into page header

[Guest]

I would like to be able to insert the contents of a cell into the Page Header
with a dynamic link back to the cell so that when the contents of the cell
change, the header will change.

 

[Frank Kabel]

Hi
not possible without VBA. You have to use the BeforePrint event of your
workbook. So try putting the following type of code in your workbook
module 'ThisWorkbook' (don't put it in a standard module):
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim wkSht As Worksheet
For Each wkSht In Me.Worksheets
With wkSht.PageSetup
.CenterHeader = wkSht.range("A1").value
End With
Next wkSht
End Sub