Function not working automatically

Try

Please Login or Register  to view this content.

Right click on "Thisworkbook", "View Code" and copy/paste above

Change highlighted as needed

Depending how often you want it to update you could add a formula to yours that will causes a refresh when the workbook calculates.

=LastModified(NOW())

Please Login or Register  to view this content.

You could try adding this as the first line of the function:

Please Login or Register  to view this content.

WBD

You could use the BeforeSave event. But you will need to kick off another routine that gets the date after the actual save. And doing so will mean the workbook would need saving again because you would have updated the cell showing the update.

How accurate does the Save date/time have to be?

So I had this as my function:

Please Login or Register  to view this content.

And I also had this in the ThisWorkbook module:

Please Login or Register  to view this content.

That seems to update the cell when the file is saved but I'm on O365 and can't test in your version.

WBD

@WBD/Phil: WBD solution (post #8) works for me for I am sure it will work on all versions of Excel (at least those post my 2010!)

That will show when the file was previously saved. The actual saving does not happen until after the calculate.
It will depend on the date format being used. So if only showing the information to the nearest day then it will appear accurate. If showing time as well it may not.

When the workbook is saved and closed the information shown on re opening the workbook will be correct.