Insert the date an Excel Workbook was last modified.

Another way would be to use a WorksheetChangeEvent macro to cause a DateTimeCode to be written to a hidden sheet to log a change to each sheet individually........knowing only if the workbook was changed is one thing, knowing which sheet was changed in even better.

hth

Vaya con Dios,

Chuck, CABGx3

 

Terrible answer. 

You failed to answer the question that was posted! 

Is there a way to insert, into a cell, the date that a workbook was last modified?

You could say this queston is technically a yes/or/no question.

But, I thinks its implied that how to do it is the request...

not just saying  '...another way would be to....' and not say how use the macro you suggest.

I use "Revised &[Date]" in the footer (w/o the quote marks). If I don't save after making changes (say to try something I end up not liking and in effect not changing the doc), then the date does not update but remains the same as when I opened the worksheet. So it is saving the date I revised it. I believe the formula also works in a cell, but I've never used it that way.

Good Luck with your project! =D

Thanks for your suggestion....but it doesn't solve this problem.

A lot of people are looking for an option to include the last date and time the file was revised on print-outs. (Different print dates don't indicate whether print-outs are identical or if there have been changes.)

While your description correctly describes the situation when viewing a file on-screen, upon printing an Excel workbook, the date/time functions automatically update. So, the feature you described will always indicate the date it was printed. Note: after printing, the date/time displayed on-screen has changed. Consistent with what you wrote, if you don't save the file, the next time you open it, the date/time will have reverted back again.

Interestingly, Word  has a feature for users to prevent fields from updating when the document  is printed. Excel does not seem  to have an equivalent feature.

This overlooked functionality is made more frustrating because Excel has a direct feature for users to view the document properties...but on-screen viewing is as far as the user interface provides.

Chip, I'm actually very well-versed in Excel and have functional knowledge of VBA, but as someone who supports the "average user" every day I'm always frustrated that the first answer to most questions involves code.  

For the vast majority of Excel users, writing a macro is NOT "simple."  I coach dozens of intelligent, educated engineers (the kind who take licensing exams and design roads, pipes, and buildings, not programmers) who barely understand anything beyond use of simple arithmetic formulas.  Functions like SUBTOTAL and SUMPRODUCT are viewed with suspicion; they turn pale if you say "macro" or "visual basic."  

The average user not only cannot write code, their installation security blocks macros and they are warned over and over NOT to disable that protection.  VBA simply is not an option for users in many network environments.  

Please, tell MVPs and other support offerors - THE SIMPLEST SOLUTION IS OFTEN THE BEST.  Simple means something I can do within the Excel environment as it opens "out of the box" without activating the Developer ribbon (there's a reason it isn't in the default setup!) or opening a secondary program (Visual Basic Editor).  

I don't apologize for the rant - it needs to be said - but I'm sorry it's aimed specifically at one MVP, you're just the one I can reach at the moment.