Hi Harley
To use code....
ActiveSheet.PageSetup.LeftFooter = Format(Date, "dd mmm yy")
Place the code in the "BeforePrint" event of the "ThisWorkbook" module of
the relevant workbook if you want it to execute each time a sheet is
printed,
--
XL2002
Regards
William
(e-mail address removed)
| How can I change the default date format (8/18/2004) in the header/footer
to
| a different date format (18-Sep-04)?
|
| Thanks
|
|