file saved

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

Guest

Does anyone have a macro for excel that puts the time the fill was lasted
saved in a cell?
 
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
 
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

Adding Quote Marks To A Very Long Column. How, Please ? 1
Excel Macro to automatically go to the right of the last colored cell 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Last Save Date 1
Save file as todays date 3
Excel Cannot delete empty cells/rows 4
How do I save a file with decimal number 2
Put Date Worksheet last saved in cell 2

Back
Top