Footer Date Format

S

Sachin

Hi

Is it possible to change the format of Date in the Header/ Foote
Say, from the default M/D/YYYY to DD/MMM/YYY

Than
Sachin
 
F

Frank Kabel

Hi
AFAIK not directly possible. But you may use the following macro (put
it in your workbook module - not in a standard module):

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim wkSht As Worksheet
For Each wkSht In Me.Worksheets
With wkSht.PageSetup
.CenterFooter = Format(date,"DD/MMM/YYYY")
End With
Next wkSht
End Sub
 
Top