Closing Excel from a Macro
Posted by Domino Pateman on November 20, 2001 4:03 AM
I'm doing a project in Excel at the moment, but there are still a few bits that I would like to perfect to do with closing Excel from a Macro. I have disenabled the x in the top corner, and when clicked it brings up a message box to tell you to go to the main page and close excel fromthe macro there (this is so that the user cannot ever close the workbook without saving the changes.) However, once they have clicked on this button on the main page to close the workbook, all it does is brings up the same msg box as before, so its a bit of a loop. Can anyone help me? I'm sorry that I can't explain myself very well.