all i can find is the =NOW() option, but I can't use NOW, i need date of last save.
i need the footer to read "Dave Evans Last Saved 3/8/2011" and the date to change each time it's saved.
Please and thank you!
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheets("Sheet1").PageSetup.LeftFooter = Environ("username") & " Last saved " & Format(Now, "mmmm dd yyyy at h:mm:ss AM/PM")
Hmm... i must be doing something wrong, it's not appearing.
I went into print preview and did custom footer just to add his name, but i notice the date and time arent changing each time i save it... it still reads 11:27am even though i've saved it since then, even with a new document name.