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

Hi anyone

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

Thank you in advance
--
Angela

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

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

"Angela" wrote:

Hi anyone

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

Thank you in advance
--
Angela

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

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


"Mike H" wrote:

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

"Angela" wrote:

Hi anyone

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

Thank you in advance
--
Angela

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

Hi,

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

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

Mike

"Angela" wrote:

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


"Mike H" wrote:

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

"Angela" wrote:

Hi anyone

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

Thank you in advance
--
Angela