| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add a date that changes only when I save the doc.
I have a file that I update and want to, when I open it, see the last time it
was updated. Is there a function that will do this? -- Thanks, Laura |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add a date that changes only when I save the doc.
Hi
One way If macro's are not disabled you can use this event to add the date/time in a cell every time you save the file (I use A1 in :Sheet1") Copy this in the Thisworkbook module of the workbook Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Sheets("Sheet1").Range("A1").Value = Format(Now, "dd-mmm-yy h-mm-ss") End Sub -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "lauras03" wrote in message ... I have a file that I update and want to, when I open it, see the last time it was updated. Is there a function that will do this? -- Thanks, Laura |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save Date & Time | Excel Worksheet Functions | |||
| why does my date change to #### when i save the page? | Excel Discussion (Misc queries) | |||
| Date each active tab upon save | Excel Discussion (Misc queries) | |||
| Input original save date | Excel Discussion (Misc queries) | |||
| How can you save a spreadsheet with a date stamp. | Excel Worksheet Functions | |||
Linear Mode
