Macro to enable the analysis toolpak VBA addin on entering a workbook??

[bsnapool]

Hi

wondering if anyone can help me?

I would like upon opening excel sheet, to automatically enable the
analysis TOOLPAK VBA addin.

IS this possible?

Thanks

Andrew

 

[Guest]

Put in the ThisWorkbook module:

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

 

[bsnapool]

Worked a treat. Much appreciated.

Thanks

Andrew