Header

Is there a way in the custom header menu to use only the
YYYY format for the date rather than the entire date.

Hi
AFAIK you'll need vBA for this. e.g. put the following code in your
workbook module:
Private Sub Workbook BeforePrint(Cancel As Boolean)
Dim wkSht As Worksheet
For Each wkSht In me.Worksheets
With wkSht.PageSetup
.CenterHead = Format(date,"YYYY")
End With
Next wkSht
End Sub

--
Regards
Frank Kabel
Frankfurt, Germany


wrote:
Is there a way in the custom header menu to use only the
YYYY format for the date rather than the entire date.