Disable Button in Excel Ribbon

[steve_p_r]

I’m using Excel 2013 with a COM add-in (which has a .vsto file extension). The add-in has added an extra tab to the ribbon, which contains a number of groups with each group having a number of command buttons.

On a spreadsheet that I have I’d like to disable one of the buttons so that users cannot use the button when using the spreadsheet. The button has a drop down arrow which produces a list of options (similar to the built in AutoSum button).

I know how to disable the built in buttons, such as bold, cut etc. or any custom buttons that I add, but cannot work out how to disable any of the buttons that the add-in has added.

Anyone got any idea how to do this?

 

[Micron]

My suggestion would be to contact the creator of the add-in because I imagine the code is not viewable by you, thus you wouldn't be able to disable it or trap it without their help. They might even have documentation they can direct you to because you're probably not the first to ask how to disable ribbon controls in the add-in.