| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date of Last Update Automatically?
Cool. Look forward to testing it out tomorrow.
Thanks much. -----Original Message----- Hi Crush If you mean last saved date of the file?? Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _ Cancel As Boolean) Sheets("Sheet1").Range("a1").Value = Date End Sub Right click on the Excel icon next to File in the menubar Choose view code Paste this event there Alt-q to go back to Excel If you save the file the date will be placed in A1 -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "Crush" wrote in message ... Is there any way to have a field that will automatically display the date of the last update? We have a calendar online that people are questioning how often it has been updating, so this would solve any issues right from the start. Thanks . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clarification - how to automatically update cells with a date and date range | Excel Discussion (Misc queries) | |||
| automatically update date | Excel Worksheet Functions | |||
| Automatically update a cell with a date based on anther cells date | Excel Discussion (Misc queries) | |||
| Update DAte Automatically | Excel Worksheet Functions | |||
| How do I get the date to automatically update | Excel Worksheet Functions | |||
Hybrid Mode
