Thread: [Solved] using "save date" in excel.
View Single Post
 
Old 06-13-2016, 04:39 AM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Hello Levi & Welcome to the Forum,

You would have to use code...

Something like this placed in the ThisWorkbook module

Code:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    Sheets("Sheet1").Range("A1").Value = Now
End Sub
http://www.rondebruin.nl/win/code.htm
Reply With Quote