VBA Excel Addin - appearing in Project explorer and not in Extras-Addins list

[george_a]

Hi,

I have an annoying addin that's appearing in the project explorer window and not in Extras-Addins list. I tried disabling it with the following code:

 
Private Sub Workbook_Open()
    Dim initialPos As Integer
    Dim FinalPos As Integer
    Dim I As Integer
    
    initialPos = 1
    FinalPos = AddIns.Count
    For I = initialPos To FinalPos
        If AddIns(I).Name = "XSFormatCleaner.xla" _
            And AddIns(I).Installed = True Then
            AddIns(I).Installed = False
            MsgBox ("Addin running, now stopped!")
            Exit For
        End If
    Next
    
End Sub

The annoying thing is that it's not in the addin list (checked with debugging and adding a watch on AddIns), yet it's behaving like an addin, running its code every time something's happening in the Excels that I opened.
Any other idea on how I can suppress this addin, so that once my workbook is opened, its code will never run until I close it?

Best regards,
George

[Simon Lloyd]

Have you searched for it on your pc?, find it and remove it or rename it.

[george_a]

Hi,

After reading some Microsoft hints, I found out why I couldn't see it anywhere in the addins, it's in the XLSTART directory.

The situation is trickyer and can't be solved by just deleting the file from my PC. Thing is all the users in the company have received this Excel file as a patch. Now, it's conflicting with one of our Excels and I'd like to disable it from running just for my Excel.

How can I disable the run of an .xla file in the XLSTART directory?

Thanks for the help and best regards,
George