software

Is there a way to insert the date a document was/is changed as opposed to the
quot;currentquot; date when the document is opened?

I'd like to indicate when actual changes to a spreadsheet occured instead of
just indicating every time the document was opened.

ThanksMaybe you could use a little macro that runs each time someone clicks File|Save?

Option Explicit
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
With Me.Worksheets(quot;sheet1quot;).Range(quot;A1quot;)
.Value = Now
.NumberFormat = quot;mm/dd/yyyy hh:mm:ssquot;
End With
End Sub

This goes under the ThisWorkbook module.

If you're new to macros, you may want to read David McRitchie's intro at:
www.mvps.org/dmcritchie/excel/getstarted.htm

dhspeller wrote:
gt;
gt; Is there a way to insert the date a document was/is changed as opposed to the
gt; quot;currentquot; date when the document is opened?
gt;
gt; I'd like to indicate when actual changes to a spreadsheet occured instead of
gt; just indicating every time the document was opened.
gt;
gt; Thanks

--

Dave Peterson