Header

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top