Help with code for add in

[Quanchi]

Hello,

I need some help with som VB code. When an Excel file is opened,
need it to check to see if the Analysis ToolPak addin is checked...i
it isn't checked...it checks it...if it is checked, it does nothing.


Any ideas?

Thanks,

Quanch

 

[JE McGimpsey]

One way:

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

 

[Quanchi]

Works great!

Thanks!

Quanch