Display last date edited in workbook
Hello,
I need to display the last date a workbook was edited. Any ideas? |
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? |
All times are GMT +1. The time now is 07:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com