One way is to create a prompt in the Workbook_BeforeClose event that asks the user if they want to close the work book
Then you can set Cancel to true before it has a chance to remove your toolbar. Therefore pre-empting excels Save dialog
You can even take care of the save yourself by using Save and setting displayalerts to false all within the Workbook_BeforeClose event.