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?


    Cheers,


    ./p

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



    Code
    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!

Register Yourself Login