Change the format of my footer {date} option?
I would like to show the date in my footer as January 25, 2005 instead of the
default 01/25/05 |
Private Sub Workbook_BeforePrint(Cancel As Boolean) With ActiveSheet .PageSetup.LeftFooter = Format(Date, "mmmm dd, yyyy") End With End Sub put this in the ThisWorkbook code module. -- HTH RP (remove nothere from the email address if mailing direct) "Tori" wrote in message ... I would like to show the date in my footer as January 25, 2005 instead of the default 01/25/05 |
All times are GMT +1. The time now is 08:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com