CODEWITHSUNDEEP
excelribbonvba
Jean-Marc Flamand
Jean-Marc Flamand

Reputation: 989

VBA - Custom Ribbon Tabs in MS Excel add-in

I develop, for our department, an MS Excel add-in that includes a custom ribbon tabs that shows up when user lunch the add-in and hide some MS Excel tabs that we do not needs. This custom ribbon includes a quit function to unload the add-in. The problem is that the company does provide some add-in with custom tab.

I would like to know, how I can hide temporary their custom tab and show them when the user quit out add-in.

Upvotes: 2

Views: 210

Answers (1)

Alan Cesar Oliveira
Alan Cesar Oliveira

Reputation: 26

You can simply enable/disable the company's add-ins, using:

Application.AddIns("name of the add in here").Installed = False

Of course, considering you know the other add-in names.

Upvotes: 1

Related Questions