Last Updated

  • Hi all!!

    I would like to have a cell in my spreadsheet that informs the user when the spreadsheet was last updated/saved, any ideas?



  • In your "ThisWorkbook" Object in your VBA Editor, add the following:

    Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
       'put code here
    End Sub

    The code will execute before a save takes place. You can then just use whatever function you want to paste the current date/time in whatever location you want.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!