Record when spreadsheet was saved in a cell

[jeddbonilla]

Hi Forum Members

I tried searching this topic on the forum board, however I don’t even know how to properly search so I need some help.

I manage an RMA spreadsheet for our company with several other co-workers that collaborate on this same shared spreadsheet. What I am wondering is if there is a way that when this spreadsheet is saved, on the actual spreadsheet, could a given cell represent the date and time it was last saved? If this isn’t possible, how about in the title?

Any suggestions you have would be greatly appreciated!

 

[AlphaFrog]

Put this code in a standard code module

Function LastSavedTimeStamp() As Date
  LastSavedTimeStamp = ThisWorkbook.BuiltinDocumentProperties("Last Save Time")
End Function

Put this formula in the cell where you want the last saved date and time.
=LastSavedTimeStamp()
And format the formula cell with any date-time format you like.

 

[jeddbonilla]

Put this code in a standard code module

Function LastSavedTimeStamp() As Date
  LastSavedTimeStamp = ThisWorkbook.BuiltinDocumentProperties("Last Save Time")
End Function

Put this formula in the cell where you want the last saved date and time.
=LastSavedTimeStamp()
And format the formula cell with any date-time format you like.

It worked! Thank you so much! This will definitely help our workflow!

 

[AlphaFrog]

You're welcome. Thanks for the feedback.