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


--
bsnapool
------------------------------------------------------------------------
bsnapool's Profile: http://www.excelforum.com/member.php...o&userid=36115
View this thread: http://www.excelforum.com/showthread...hreadid=561650

Put in the ThisWorkbook module:

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



"bsnapool" wrote:


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


--
bsnapool
------------------------------------------------------------------------
bsnapool's Profile: http://www.excelforum.com/member.php...o&userid=36115
View this thread: http://www.excelforum.com/showthread...hreadid=561650

Worked a treat. Much appreciated.

Thanks

Andrew


--
bsnapool
------------------------------------------------------------------------
bsnapool's Profile: http://www.excelforum.com/member.php...o&userid=36115
View this thread: http://www.excelforum.com/showthread...hreadid=561650