You need to do that with a Before_Print event macro. If you search the
newsgroups from Google you will find lots of examples.

On Fri, 4 Feb 2005 09:33:04 -0800, "Last modified date in footer" <Last
modified date in wrote:

How do I enter the date last modified in the footer of an Excel document?
I want to be able to distribute a monthly or weekly report in Excel to users
and have it automatically update the date last modified in the footer each
time I update the report.