Date last modified

  • Thread starter Thread starter judith
  • Start date Start date
J

judith

Is there any way I can access the date a spreadsheet was
last modified please? (as in the date displayed in
explorer)
 
Press Alt + F11, in the left project pane find your workbook, double click
ThisWorkbook and paste the below

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Worksheets("Sheet1").Range("A1").Value = Now()
End Sub

press Alt + Q to close the VBE, save and close and restart excel. From now
on every time you (somebody)
save the workbook that particular date and time will show in A1 in Sheet1,
if the name of your worksheet
differs just replace "Sheet1" with the name of your worksheet and replace
"A1" with the cell where you want this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula that displays the documents modified date 4
Date Last Modified 3
Date/Time When content of a Worksheet is Modified 1
Save Date 1
Last Date Modified 2
formula to display Modified properties 1
Modified Date Variable 4
Finding second-to-last workday of month 4

Back
Top