| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display last date edited in workbook
Hello,
I need to display the last date a workbook was edited. Any ideas? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display last date edited in workbook
Hi Kathy
the following code will display in cell A1 the date the workbook was saved the last time: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Range("A1").Value = Date End Sub put this in your workbook module and save the file HTH Frank kathy wrote: Hello, I need to display the last date a workbook was edited. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display "Last updated date" for the Workbook (without using a macr | Excel Worksheet Functions | |||
| Workbook Name Edited in Cell | Excel Worksheet Functions | |||
| set up a shared workbook to be view/edited at the same time? | Excel Discussion (Misc queries) | |||
| Display last date workbook was modified? | Excel Discussion (Misc queries) | |||
| Date last edited | Excel Discussion (Misc queries) | |||
Linear Mode
