Last Modified Date (

Searching through the forum, I have found several types of "code" that will make Excel provide the last modified date (not to be confused with the last saved date). However, I am missing the middle step. What do I do with this code to use within Microsoft Excel?

Thus, can anyone provide step by step instruction on how to add the last modified date, as a footer to an excel worksheet, and where in the workbook should the "code" be kept?

These are the hyperlinks to the "code" I have located thus far.
Answer Number One:
Website: http://www.excelforum.com/excel-gene...fied-date.html
Answer:I have the following code in my Book.xlt file, but you can add it to your file. It needs to be in "This WorkBook", not in a module. If the file is new, you might have to save it twice before it appears in the footer. It doesn't mention the User, just the date/time it was last updated.

Answer Number Two:
Website: http://office.microsoft.com/en-us/ex...010218996.aspx
Answer: Create Custom Functions in Excel 2007 using VBA
[U][U]Answer Number Three:
Website: http://www.mrexcel.com/archive/Dates/17403b.html
Answer: You can add this as a User Defined Function:

Public Function ModDate()
   ModDate = Format(FileDateTime(ThisWorkbook.FullName), "m/d/yy h:n ampm")
End Function