Does anyone have a macro for excel that puts the time the fill was lasted saved in a cell?
G greg Nov 3, 2004 #1 Does anyone have a macro for excel that puts the time the fill was lasted saved in a cell?
F Frank Stone Nov 3, 2004 #2 hi In the workbooks before save event add the following code Private Sub Workbook_BeforeSave(Cancel As Boolean) Sheets("yoursheet").Range("A1").FormulaR1C1 = Now() End Sub
hi In the workbooks before save event add the following code Private Sub Workbook_BeforeSave(Cancel As Boolean) Sheets("yoursheet").Range("A1").FormulaR1C1 = Now() End Sub
