C
CherylH
I currently have the following code in order to capture the 'last saved
date', however I need to also add the 'last saved TIME'. What do I need to
add to this in order to capture the time as well?
Thanks in advance for any help!
Cheryl
==================================================
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
ActiveSheet.PageSetup.LeftHeader = "Last Update:" & Date
End Sub
==================================================
date', however I need to also add the 'last saved TIME'. What do I need to
add to this in order to capture the time as well?
Thanks in advance for any help!
Cheryl
==================================================
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
ActiveSheet.PageSetup.LeftHeader = "Last Update:" & Date
End Sub
==================================================