Pre-Ribbon AddIns - Fail to Reset the AddIns Tab

[Stephen W Allen]

I created 4 AddIns, around 2000 to 2007, which have not been upgraded to Ribbon status, but have still been accessible in the AddIns tab. Each, of these AddIns, is based on a standard menu.

Each AddIn contains an instructiom in the Wookbook_BeforeClose procedure-

Application.CommandBars("Worksheet Menu Bar").Rese

t. This has workked successfully up until Excel 2013.

In Excel 2019 it fails, in the sense, that when Excel is reopened is duplicates part of the menu. After several iterations the menu becomes clogged with repetitions. It appears that Excel takes an image of the menu tree (or part of it ) and adds to it each time the user reopens Excel. Is there a VBA method to stop this?

 

[RoryA]

A gentle reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Menu bar 'Reset' not working in Excel 2019 [SOLVED]

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. Private Sub Workbook_BeforeClose(Cancel As Boolean) Call Reset...

www.excelforum.com

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Stephen W Allen]

A gentle reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Menu bar 'Reset' not working in Excel 2019 [SOLVED]

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. Private Sub Workbook_BeforeClose(Cancel As Boolean) Call Reset...

www.excelforum.com

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Thank you Rory. I should have provided the cross posting information and the link. However, in my defence, I have changed the emphasis of the question. Also, you may note that

 

[Stephen W Allen]

The solution turned out to be relatively simple.

The original Sub was called Reset() which generates a confusion with the Reset instruction. Renaming the Sub as follows did the trick.

Sub ResetBar()

Application.CommandBars("Worksheet Menu Bar").Reset

End Sub

 

[RoryA]

Wouldn't it be worth the time to update them to use the Ribbon?

 

[Stephen W Allen]

Wouldn't it be worth the time to update them to use the Ribbon?

For a couple of them, yes. However, these are fairly substantial programs and really need a review before converting them to a ribbon.

Also, finding suitable icons for the active procedures and functions can be quite tedious. No doubt, I'll get around to it if retirement becomes too boring.

Stephen