| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding "last saved date" to header
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 ================================================== |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a "last saved on date/user" macro/function for Excel 2003 | Excel Discussion (Misc queries) | |||
| "Last Saved" date in Excel 2000 | Excel Worksheet Functions | |||
| Solution "Your changes could not be saved" "The document may be read-only or encrypted" | Excel Discussion (Misc queries) | |||
| how do I insert "last saved date" in as a field in excel? | Excel Worksheet Functions | |||
| .csv drops "0" when saved, even if file was set as "text". | Excel Discussion (Misc queries) | |||
Threaded Mode
