enable analysis toolpak
 

This is not what I was looking for. I'm looking for a vbs or other script
that will automatically add this add-in to all computers across a network,
not just one single pc. I found the registry setting that controls this, but
not sure how to create it into a batch file to edit this registry setting on
all workstations. That is what I am looking for.



__________________________________________________ ________________
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
---------------
Jacob Skaria


"pete0085" wrote:

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?