VBA Excel - Issue activating Add in?

I dont know if anyone can help with this, BUT...

I have an Excel Workbook that uses the "Analasys Toolpak" add-in, and also the "Analasys Toolpak - VBA" add-in. Everything seems to work fine until I send this workbook to another user, and as soon as they open it, the get "Automation Error" messages. The issue seems to be that the Add-Ins are not active on their machines.

This all worked fine until I started using the "Analasys Toolpak - VBA" Add-In.

I can load the "Analasys Toolpak" Add-In within the Workbook_Open() function, but this seems to be to late for the VBA toolpak?

Is there a way I can force Excel to load this Add-In and not cause the Automation Errors?

Any ssistance would be greatly appreciated....

Automation errors typically occur when the add-in or referenced OLE object is not found on the machine opening the Excel workbook.

That was my initial thought as well, however the Add In in question IS installed. If I activate the Add-In Manually before opening the Workbook, everything works fine, however, if the Add-In is not loaded prior to opening the Workbook, I then get these Automation Errors.

I just need some way to activate the Add-In before the error occurs, and preferably without the user having to do it manualy?

What version of Excel? If you're talking about a newer version like 2007, you won't be able to due to the new security features. Users must enable things themselves.