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.

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

--
Regards
Frank Kabel
Frankfurt, Germany

"ScottyV" schrieb im Newsbeitrag
...
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.