When you go to vba editor,

go to view-project explorer, this will make project explorer visible
it is visible by default.

Go to project explorer toolbar,now you will see vb
project(your_file_name), double click it to expand, double clic
"microsoft excel objects" to expand, now you see "this workbook"
double click the "this workbook" and 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 Su

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