load .xla addin's when open Excel sheet.

[Lars Schouw]

Do you know how to load .xla addins when I open an Excel sheet and
there by avoiding references to addins from my Excel sheet?

Lars

 

[Halim]

place this code behind Sheet :
Private Sub Worksheet_Activate()
AddIns("addinsample").Installed = True
End Sub

Private Sub Worksheet_Deactivate()
AddIns("addinsample").Installed = False
End Sub