MrExcel.com - Your One Stop for Excel Tips & Solutions

Save Date in Footer

Posted by Morry Simon on November 09, 2001 8:11 AM

In the footer, Excel only allows the option of the current date "&[date]". Can that be modified to be the save date, similar to what Word allows?

Posted by Juan Pablo on November 09, 2001 8:20 AM

I think you could use the

Workbook_BeforeSave() event and put a line that states something like

Sheets("Sheet1").PageSetup.CenterFooter = Date

This way the Center footer will have the Date on which the file was saved.

Juan Pablo