Can I Add the last saved Date to cell ref in excel?

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

Guest

Hi anyone

How can I add the last saved date to a cell ref in excel?

Thank you in advance
 
Hi,

Alt+F11 to open Vb editor.
Double click 'This Workbook' and paste this in

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Worksheets("Sheet1").Range("A1").Value = Now
End Sub

Mike
 
Thanks for replying Mike. Should I also add =lastsave() to A1 cell of Sheet1?
 
Hi,

You can add whatever text you want, the correct syntax is

Worksheets("Sheet1").Range("A1").Value = "Last saved date " & Now

Mike
 
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

Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
GETPIVOTDATA #REF! error XL2003/2010 1
Macro to change formula? 5
Help to create a macro 2
getting values from a filename as a date in a cell 11
Using a #Ref! in a column Sum 3
Excel How to add numbers in same cell? 2
#Ref! after row deletion 3

Back
Top