Insert the date an Excel Workbook was last modified.

Anonymous

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.

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

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

0 comments

86 additional answers

Anonymous

2014-10-01T18:45:51+00:00

Pearson, do you know why it's showing me the result: 41,709.56 after I use this user-defined function? I have Excel 2013. Thank you.
Was this answer helpful?

0 comments No comments
Anonymous

2014-09-13T18:53:35+00:00

Chuck,

Thanks for the greetings. Glad to hear were both still around!

And happy birthday to you on the 19th.

'---

Jim
Was this answer helpful?

0 comments No comments
Anonymous

2014-09-13T16:42:12+00:00

Hey Jim......

Good to see you still around.

Happy Birthday on the 19th.

Chuck, CABGx3
Was this answer helpful?

0 comments No comments
Anonymous

2014-09-13T14:48:36+00:00

Re: Where's "ALY+F11"?

That is a typo and should read "Alt + F11".

It applies to the keyboard and means press the Alt key and tap the F11 key once.

'---

Jim Cone

Portland, Oregon USA

free & commercial excel programs (n/a xl2013)

https://jumpshare.com/b/O5FC6LaBQ6U3UPXjOmX2

-or-

http://jmp.sh/K95N3ee
Was this answer helpful?

0 comments No comments