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?
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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
