VBA: Disable all addins except one predefined addin

[excelstarter1]

Hey guys,

I tried the following code to deactivate all running addins except one addin which I want to keep. However, I always get runtime error "Subscript out of range (Error 9)" in the Installed = False line of my code. I was not able to deactive any addins so far... Do you have a better approach or an improvement of my code?

Thanks in advance!
Regards

Sub DeactivateAddIns()
Dim i As Integer
Dim MyaddInName As String

For i = 1 To AddIns.count
MyaddInName = AddIns(i).Name
If MyaddInName = "AddinIWantToKeep" Then 'Skip the Addin I want to keep
Else
Application.AddIns(MyaddInName).Installed = False 'Deactivate all addins
End If
Next i

End Sub

 

[Jaafar Tribak]

Do you have any XLL addins ?

anyway give this a try and see if it works :

Sub DeactivateAddIns()
    Dim oAddin As AddIn
    Dim MyaddInName As String
    
    MyaddInName = "AddinIWantToKeep"
    For Each oAddin In AddIns
        If InStr(UCase(oAddin.Name), UCase(MyaddInName)) = 0 Then 
            oAddin.Installed = False
        End If
    Next
End Sub

 

[excelstarter1]

Thanks! Yes, I also have XLL and COM Addins and I want to deactive all of those running addins.

I will try your code and let you know.

 

[excelstarter1]

Great, it does work for my "regular" Excel-Addins.

Do you know an approach how to deactivate COM and XLL addins? Especially COM addins...

Is there a way to (1) store all active addins in a variant/variable, (2) run my macro without these addins interfering/slowing down (3) and then reactive the addins again after macro is completed?

Thanks!

 

[Jaafar Tribak]

Great, it does work for my "regular" Excel-Addins.

Do you know an approach how to deactivate COM and XLL addins? Especially COM addins...

Is there a way to (1) store all active addins in a variant/variable, (2) run my macro without these addins interfering/slowing down (3) and then reactive the addins again after macro is completed?

Thanks!

Hi excelstarter1,

I am not quite familiar with xll or com addins so I can't advise you . hopefully someone with the knowledge who visits this thread can help.

Have you tried googling the subject ? I am sure you will find some code examples.