Microsoft Office Forums - View Single Post - Detect in VBA if document has been changed

macropod · 04-28-2014, 05:49 AM

You can test the Saved state (e.g. If 'Document.Saved = False') to tell you whether the document has been edited but, unless you're doing some form of before/after comparison, you'll have no way of knowing what those changes were. And, unless you trap all saves as well, testing the Saved state won't even tell you whether the document was changed while it was open.