I want to make sure that anyone who runs a report will have an Add-in
set to True on their computer before they start.
I tried putting this line in the This Workbook module, but nothing
happens.

Sub AddInsSet()
AddIns.Add("Analysis ToolPak").Installed = True
End Sub

Any suggestions??
Thanks
jeff

Just because the procedure is behind ThisWorkbook doesn't mean that it'll run
automatically.

The workbook_open event is the built-in event that you wnat to use:

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

wrote:

I want to make sure that anyone who runs a report will have an Add-in
set to True on their computer before they start.
I tried putting this line in the This Workbook module, but nothing
happens.

Sub AddInsSet()
AddIns.Add("Analysis ToolPak").Installed = True
End Sub

Any suggestions??
Thanks
jeff

--

Dave Peterson

On Jun 26, 7:34*am, Dave Peterson wrote:
Just because the procedure is behind ThisWorkbook doesn't mean that it'll run
automatically.

The workbook_open event is the built-in event that you wnat to use:

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

wrote:

I want to make sure that anyone who runs a report will have an Add-in
set to True on their computer before they start.
I tried putting this line in the This Workbook module, but nothing
happens.

Sub AddInsSet()
AddIns.Add("Analysis ToolPak").Installed = True
End Sub

Any suggestions??
Thanks
jeff

--

Dave Peterson

Thanks Dave. I screwed up. I didn't put this in the Workbook_Open
section.
It works fine now. Thanks for the reply. I appreciate it.
jeff