![]() ![]() Next time when you open the workbook, you can just use the shortcut key to show the last modified time to the cell you want. Meanwhile, you can add another macro to skip the step of insert formula manually.įollow the steps 1,2 mentioned above to create a new module, type in the following script:ĭevelop tab, select the macro and click Options, then assign a shortcut key to the macro. ![]() =lastmodified(), if the time doesn't displayed as expect, you can change the cell format to Close VB editor and save the workbook as a macro-enabled workbook, open the workbook again, in the cell you want to display the last modified time, insert LastModified = ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")Ĥ. Since you are using Excel 2016 for Mac, I will show you how to do it on Mac.ĭevelop tab, if you don't have it, go to Excel > Preference > Ribbon > check the Google Docs brings your documents to life with smart editing and styling tools to help you easily format text and paragraphs. ![]() You can create a macro based on the article you provided to send back the last modified time in your workbook.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |