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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Header/Footer Date Format 2
excluding column headers from formulas 3
Need help with access expression - HELP!! 0
Dates not honoring Regional/Language Options 0
SAVE AS CSV, KEEP DATE FORMAT 2
Format date in header 4
Date format problems after csv import 2
How do I sum a column based on 2 different column headers/criteria? 0

Back
Top