Insert the date an Excel Workbook was last modified.

Anonymous
2010-11-17T00:13:29+00:00

Is there a way to insert, into a cell, the date that a workbook was last modified?

Perhaps by getting the modified date from the file's properties into a cell.

Thanks in advance.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2010-11-17T00:29:39+00:00

Hi,

To modify a workbook you have to save it so we can use the before_save event

ALY+F11 to open vb editor. Double click 'ThisWorkbook' and paste this code in on the right. Change the sheet and range to suit

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

Sheets("Sheet1").Range("A1").Value = Now

End Sub

If this post answers your question, please mark it as the Answer.

Mike H

Was this answer helpful?

100+ people found this answer helpful.
0 comments

86 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-03-21T15:40:19+00:00

    Many thanks I copied this code and it works well.

    Do you need to add the brackets to the Now function?

    =now()

    Many thanks

    Flora

    Was this answer helpful?

    0 comments
  2. Anonymous
    2015-03-10T15:25:17+00:00

    Thanks for you work on this question.

    The directions are easy to understand and I got the new function to work. However, when saving the VBA, you first need to save the workbook as a macro enabled one (.xlsm). I am using Excel 2013.

    Is there a way to get this function to work in a header or footer? So far I have not found a way.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2015-01-23T17:35:40+00:00

    Thank you, Dinesh - this worked perfectly for me.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2014-11-13T20:38:58+00:00

    Hello Chip,

      This function works just fine in Excel 2010. Thanks.

    Was this answer helpful?

    0 comments