Hi

Use this two events in the Thisworkbook module.
Read more about events on Chip Pearson's site.

http://www.cpearson.com/excel/events.htm

Private Sub Workbook_Activate()

End Sub

Private Sub Workbook_Deactivate()

End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"LRL" wrote in message ...
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