Thread: Macro to enable the analysis toolpak VBA addin on entering a workbook??
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JMB JMB is offline
external usenet poster
  
Posts: 2,062
Default Macro to enable the analysis toolpak VBA addin on entering a workb
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


Reply With QuoteReply With Quote