Thread: Want only current year in header/footer - How?
View Single Post
 
Old 12-05-2019, 06:09 PM
jeffreybrown jeffreybrown is offline Windows 10 Office 2016
Expert
  
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default
Just run this macro once a year. No need to store a date on the worksheet.

Code:
Sub add_date_header()
    ActiveSheet.PageSetup.CenterHeader = Format(Date, "yyyy")
End Sub
Reply With Quote