footers

[TCN]

If you use the Page Setup featire to creat a custom footer then how can you
modify the date to another format rather than the one that is provided?

 

[Frank Kabel]

Hi
not possible without using VBA

--
Regards
Frank Kabel
Frankfurt, Germany

If you use the Page Setup featire to creat a custom footer then how can you
modify the date to another format rather than the one that is

provided?

 

[JE McGimpsey]

You could run an event macro (see

http://www.mvps.org/dmcritchie/excel/getstarted.htm

if you're unfamiliar with macros). Put this in the ThisWorkbook code
module:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim ws As Worksheet

For Each ws In ActiveWindow.SelectedSheets
ws.PageSetup.LeftFooter = Format(Date, "dd mmm yyyy")
Next ws
End Sub

Change the date format within the quotes as desired.