OK, a problem: I have a macro which goes through my workbook, and deletes some sheets, and deletes a module in my workbook. This all works fine. But, in my before close event, i have a piece of code which saves the workbook, thus preventing the Save Question box from coming up (well, supposed to). The problem is, when i run my code which deletes the module and sheets, and then close the workbook, the save question STILL comes up! (if i do NOT run the code which deletes, there is NO save message). The big problem here is that IF the user for some reason clicks "no" to the save question, it corrupts the excel file, and i can no longer open it!
I do not want to use the code "application.displayalerts=false" because there may be other workbooks open which i DO need alerts.
Can anyone think of any solutions? I would post my code, but theres a ton of it. let me know if you really need it, thanks.
I do not want to use the code "application.displayalerts=false" because there may be other workbooks open which i DO need alerts.
Can anyone think of any solutions? I would post my code, but theres a ton of it. let me know if you really need it, thanks.