Hell

I can catch a workbook close just fine but if someone clicks on the X button in the corner of Excel to close the whole application my macro doesn't work quite right

I've got a little progress bar that I like to run when the workbook is closed in order to monitor that it deletes everything it needs to delete. But if the user pushs the application close button this userform loads but then does not run the userform_activate statement. Anyone have any ideas?