Paste the following formula into the cell: =LastModified() Now return to the worksheet and click on the cell where you would like to display the last modified date. LastModified = ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")Īnd click on the Save button (button looks like a disk). Paste the following macro code into the new module: Function LastModified() as Date Then create a new module by selecting Module under the Insert menu. However, you can create a Macro function that will return this value.įirst, open the Visual Basic editor by pressing Alt+ F11. Question: In Microsoft Excel, how can I autoupdate a date on an Excel worksheet to the Last Modified Date?Īnswer: There is no built-in function in Excel that will return the last modified date of an Excel Workbook (ie: Excel file). This Excel tutorial explains how to write a macro that returns the last modified date for the Wookbook and displays that date value in a cell (with screenshots and step-by-step instructions). MS Excel: Function that returns Last Modified date for Workbook
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |