add a date that changes only when I save the doc.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a file that I update and want to, when I open it, see the last time it
was updated. Is there a function that will do this?
 
Hi

One way

If macro's are not disabled you can use this event to add the date/time in a cell
every time you save the file (I use A1 in :Sheet1")

Copy this in the Thisworkbook module of the workbook

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheets("Sheet1").Range("A1").Value = Format(Now, "dd-mmm-yy h-mm-ss")
End Sub
 
You must log in or register to reply here.

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

How to unlink TOC from a doc 0
Configuration of WordPress for enabling updates eg plugins and WordPress itself.. 1
Which is the best MBOX Converter Tool different formats conversion? 5
How do I display the most recent "modified" date in Excel sheets? 5
=NOW() 2
Word Macro to insert text and save as PDF 4
Date function in Excel that updates only when a doc is changed? 1
Any formula to insert last document saved date ? 1

Back
Top