footers

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

Guest

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?
 
Hi
not possible without using VBA

--
Regards
Frank Kabel
Frankfurt, Germany

TCN said:
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
Click to expand...
provided?
 
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.
 
Back
Top