enable analysis toolpak

[pete0085]

Anyone have any ideas how I can enable the analysis toolpak in Excel 2003
using a script of some kind to easily add this for every user on the network?

 

[Jacob Skaria]

Set the Security level to low/medium in (Tools|Macro|Security). From workbook
launch VBE using short-key Alt+F11. On the left treeview double search for
VBA Project for the workbook and click + to expand . Double click 'This
Workbook ' and paste the below code..which should install ATP on workbook open

Private Sub Workbook_Open()
Dim strATP As String
strATP = "Analysis ToolPak" ' "Analysis ToolPak - VBA"
blnATP = Application.AddIns(strATP).Installed
If Not blnATP Then Application.AddIns(strATP).Installed = True
End Sub

If this post helps click Yes