Set an Add-In to This Workbook module

  • Thread starter Thread starter wpreqq99
  • Start date Start date
W

wpreqq99

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
 
Just because the procedure is behind ThisWorkbook doesn't mean that it'llrun
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
Click to expand...

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
 
Back
Top