Whenever a user saves, I run through a special set of coding to save the file for them. If certain fields are blank, then I warn them and the file isn't saved. This works great, except when they close the workbook and save the file because if it fails, then the workbook still closes. The problem being that the BeforeClose event fires before it asks if they wish to save, so I can't use the BeforeClose event to cancel the close if the save fails.
So, is there a way to cancel a close outside of the BeforeClose event?
Bookmarks