For some reason the project explorer wasn't visible by default. Than
you for your help, that got it to work and startup and close. However
what I needed was for the addins to be deactivated and then reactivate
as soon as the file opens (for some reason, this is the only way i
works, and I have no idea why). I used this code instead:

Private Sub Workbook_Open()
addins("Analysis ToolPak").Installed = False
addins("Analysis ToolPak - VBA").Installed = False
addins("Conditional Sum Wizard").Installed = False
addins("Lookup Wizard").Installed = False
addins("Solver Add-in").Installed = False
addins("Analysis ToolPak").Installed = True
addins("Analysis ToolPak - VBA").Installed = True
addins("Conditional Sum Wizard").Installed = True
addins("Lookup Wizard").Installed = True
addins("Solver Add-in").Installed = True
End Sub

Now it works.

Thank you very much for your help

--
Andrew
-----------------------------------------------------------------------
Andrew-'s Profile: http://www.excelforum.com/member.php...fo&userid=2475
View this thread: http://www.excelforum.com/showthread.php?threadid=38327