Inserting Last Date Modified in Footer
 

I'm trying to create a footer in Excel 2003 with the lastest date and time
when a worksheet was modified. I have about 20 workbooks with 4 worksheets
in each one with some of the workbooks and worksheets linked. The date needs
to change for any individual worksheet I change and any linked worksheets
that actually change because of changes to another. I don't want the date or
time to change if the file is just opened or saved. Has anyone written
Visual Basic code that will do this?