My understanding is that if you modify any of the built-in menus or controls in VBA the customisation is stored in the Excel.xlb file and will apply to future Excel sessions. The way to avoid this is to reverse the customisation before the Excel application closes, say in a Workbook_BeforeClose event.

I have an application using a workbook set up as an add-in and, although I am detecting application events in a class module, the Before Close event doesn't occur for the add-in workbook as it isn't classed as a workbook.

How can I remove menu customisation just before the application closes?