It should work.

You have the paste the code at correct location.
go to tools-macro-visual basic editor- double click "this workbook",
paste the below code.






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
End Sub


Private Sub Workbook_BeforeClose(Cancel As Boolean)
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


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=383279