Found out that adding to the VB Module behind the spreadsheet does not actually register as a Macro.
So here is the solution:
- Press ALT + F11
- Click Insert > Module
- Paste the following into the window:
Function LastSavedTimeStamp() As Date LastSavedTimeStamp = ActiveWorkbook.BuiltinDocumentProperties("Last Save Time") End Function
- Save the module, close the editor and return to the worksheet.
- Click in the Cell where the date is to be displayed and enter the following formula: