I am having some trouble getting a macro to work that is used to back up the change history in a shared workbook. Below is my code. I've left in some message boxes that I have been using to debug.

Please Login or Register  to view this content.
When I add information to a cell (such as adding a date), it will not save the file, therefore not being able to copy the changes from the history tab. If I clear the contents of the cell (press "delete") then it runs as expected, saving the workbook and copying the changes. Any idea what could be causing this?