| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically show modified date?
When I save changes to my current worksheet, is it possible have a formula in
A2 to display today's date (based on the condition that changes were saved to the current worksheet)? A1 contents: "Information on this worksheet was last updated on:" A2: "today's date" (if in fact "today", changes were made and saved) Thanks!! :) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
automatically show modified date?
Hi
Try something like this. You copy the code to ThisWorkbook in VBA. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Worksheets("name of the sheet").Range("cell address").Value = Date End Sub Change the sheet and range. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Tacrier" wrote: When I save changes to my current worksheet, is it possible have a formula in A2 to display today's date (based on the condition that changes were saved to the current worksheet)? A1 contents: "Information on this worksheet was last updated on:" A2: "today's date" (if in fact "today", changes were made and saved) Thanks!! :) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
automatically show modified date?
Awesome. Thank you!! :)
"Wigi" wrote: Hi Try something like this. You copy the code to ThisWorkbook in VBA. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Worksheets("name of the sheet").Range("cell address").Value = Date End Sub Change the sheet and range. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Tacrier" wrote: When I save changes to my current worksheet, is it possible have a formula in A2 to display today's date (based on the condition that changes were saved to the current worksheet)? A1 contents: "Information on this worksheet was last updated on:" A2: "today's date" (if in fact "today", changes were made and saved) Thanks!! :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically show date day by day | Excel Worksheet Functions | |||
| how to show the date a spreadsheet was modified in a cell | Excel Discussion (Misc queries) | |||
| Show date cell modified | Excel Worksheet Functions | |||
| In adjacent cell, show last date modified of target cell. | Excel Discussion (Misc queries) | |||
| Expired date to show up automatically | Excel Discussion (Misc queries) | |||
Hybrid Mode
