I liked the sound of using VBA to enable the ToolPak, but I guess your
suggestion of notification is the best. If a user didn't install the ATP
during setup, I would have to go the simple notification route anyway. I just
added the appropriate instructions to a "Help" sheet in the workbook.

Thanks for the help.
~ Horatio


"Bob Phillips" wrote:

That only works if it was installed when Excel was installed.

--
__________________________________
HTH

Bob

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
You could take it out of their hands and enable the add-ins yourself.

Private Sub Workbook_Open()
AddIns("Analysis ToolPak").Installed = True
AddIns("Analysis ToolPak - VBA").Installed = True
End Sub

Be sure to change to False on closing the workbook.

If you just want a message as you asked use this example code in
workbook_open

Private Sub Workbook_Open()
Set a = AddIns("Analysis ToolPak")
If a.Installed = True Then
MsgBox "The ATP add-in is installed"
Else
MsgBox "The ATP add-in is not installed"
End If
End Sub


Gord Dibben MS Excel MVP

On Wed, 21 Jan 2009 07:47:02 -0800, Horatio J. Bilge, Jr.
wrote:

I created a workbook that requires the Analysis ToolPak and Analysis
ToolPak-VBA add-ins to function. I've discovered that many of the people I
gave the workbook to do not have those add-ins enabled, so they get the
#NAME? error.

Is there a way to automatically check for the Analysis ToolPak? I am
thinking that if the ToolPak is not enabled, a message box would pop up
telling the user what the problem is, and how to install the ToolPak.

Thanks!