I have a custom menu which I delete in the Workbook_BeforeClose subroutine.
If the user cancels the save, the menu is gone but the spreadsheet is still
open.

I need to be able to delete the menu under the conditions that the user goes
ahead and either saves or doesn't save the spreadsheet but closes it, as well
as retaiin or recreate the menu under the condition that he cancels the
save/don't save and keeps the spreadsheet open.

Any ideas?

Thanks

Leslie