Menu bar 'Reset' not working in Excel 2019

I use several ancient Add-Ins, built before the introduction of the Ribbon. The standard way to prevent the menu bar from getting cluttered with repeat versions of the same menu, was to use the Reset function on closing Excel.

Please Login or Register  to view this content.

This Reset function fails to operate in my copy of Excel 2019.

Does anyone have an alternative solution?

Thank you Artik. Here is the essential parts of the code from one of the Add-Ins. Sorry, it is quite extensive.

Please Login or Register  to view this content.

Originally Posted by Artik

Try it:
4. the body of the ResetBar procedure:

Please Login or Register  to view this content.

If it still doesn't work, I'll come back to the problem in a few hours as I'll be busy now.

Artik

Sorry Artik, but the code fails at point 4 above. But the notion of renaming Reset() to ResetBar() is good and I'll definitely keep it.

Further to my post above.

1. The ResetBar() fails when called from the Workbook_BeforeClose procedure, but does NOT fail when called directly.

2. A memory of the previous state of the Menu tree is still retained and added to when I close and reopen Excel. The branches of this menu are getting longer and longer.

3. Curiously this does not happen in Excel 2013. I only observe it in Excel 2019.

Originally Posted by Artik

Try it:
1. rename the procedure "Reset" e.g. to "ResetBar"
2. in the procedure Workbook_BeforeClose call:

Please Login or Register  to view this content.

3. in the listBars procedure, change the line:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

4. the body of the ResetBar procedure:

Please Login or Register  to view this content.

If it still doesn't work, I'll come back to the problem in a few hours as I'll be busy now.

Artik

It took a little testing to identify what worked. It turns out the renaming of the Reset procedure, suggested by you, is crucial. However, to reiterate your proposal at point 4 fails.

Nevertheless the following code works for each of the addins.

Please Login or Register  to view this content.

I appreciate your deprecating the use of Reset, but in this case I need to stick with what works.