Hi Dave

Application.AddIns("Analysis ToolPak").Installed = True

Not all users have this Add-in installed and if they use a other language version it will not work
because ATP functions will not translate.

Maybe you can use functions that not use this Add-in


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Dave" wrote in message ...
I'm emailing a workbook to a group of recipients. The workbook contains cells
that require the Analysis Toolpak add-in. Of course, when I open the workbook
the toolpak is active. How do I program the workbook to automatically
activate the toolpak on other computers when recieved via email?

Thanks for your help!