View Full Version : VBA Excel Addin - appearing in Project explorer and not in Extras-Addins list

02-16-2010, 02:38 AM

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

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,

Simon Lloyd
02-16-2010, 06:00 AM
Have you searched for it on your pc?, find it and remove it or rename it.

02-16-2010, 07:09 AM

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,