Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display last date workbook was modified?
I would like to have a cell display the last date a workbook was modified.
What would the code for that be? Thanks in advance for any help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display last date workbook was modified?
You could use a Worksheet_change or Workbook_beforesave macro to populate a cell with the current date/time. e.g. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Sheets(1).Cells(1, 1) = Date End Sub pasted into the thiswokbook tab in the VBA editor (Shift F11) -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=563356 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display Date that does not change everyday. | Excel Discussion (Misc queries) | |||
Simple Date Display Question | Excel Discussion (Misc queries) | |||
i want to display the month from a date into another cell | Excel Worksheet Functions | |||
bringing data from one workbook to another using a date stamp func | Excel Worksheet Functions | |||
Modified Date | New Users to Excel |