I have a finance and budget program using Excel primarily as a method of input and output reports. Most if not all functioning is VBA code. The problem I am having is that when I click the X to exit the workbook I have a message box (my own creation) open to as if I want to save the workbook to the three locations I have programmed into it before I get out, or to just skip it and exit (Yes or No) response. I have found that at my age I occasionally hit the X (exit) button when I mean to use the full-screen button, or just plain am not thinking. As a result, there is no way out of the message box except to exit the workbook. I want to add an abort button to effectively say oooooops, I made a mistake, get out of the close routine. Sort of like the Cancel choice of the Save, Don't Save, Cancel message box you get if you have unsaved changes. I can't make anything work. If I put "Cancel = True" in the close it never goes out of the workbook. I tried to make a conditional statement to establish the Cancel feature but it seems to ignore conditional in the "before close" section. Any suggestions that I can understand without getting too deep into OOP?