Can't delete custom menu group created in VBA

[AngieJD]

Hi,

I created a custom menu in vba using this command line:

Set KeepaButton = Application.CommandBars("Tools").Controls.Add(Type:=msoControlButton)

I cannot get rid of the now empty menu group "Menu Commands" now being displayed on the Add-Ins tool bar and it is driving me crazy, I could right click the menu item and delete, which I did!

MenuCommands.png

I have tried to sort it through Customize Ribbon, but the Menu Commands item is greyed out along with the Remove button.

customizeribbon.png

I am assuming I will have to do this programmaticaly, but I can't see how!

I would really appreciate some help!!!

Thanks you!

[Arkadi]

What is the actual name of the control you added?

[davesexcel]

Wherever you found the code to add the group, you should be able to find the code to delete the group.

[Arkadi]

My guess would be that you didn't set the .Caption property on your custom menu item, thus you can probably find it because it is the only one without a caption... Thus not truly "empty". Thats just a theory... but if you did that (not giving it a caption) even once, then it would behave this way. I tried running your one line of code to add and got an empty menu just like you, and the below fixes that.

Please Login or Register  to view this content.

[AngieJD]

You are a star! Thank you so much. That worked! :-)

[Arkadi]

Glad to hear it AngieJD! Thanks for marking the thread as solved, and the feedback