load .xla addin's when open Excel sheet.

L

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XLA file in project 4
finding AddIns folder 1
XLS files link to XLA files 1
How to create XLA? 2
When do AddIns load? 1
Trouble Installing Excel VBA Code Cleaner into Office 365 0
Issues with Referencing .XLA file on a Server 11
macros in my custom xla Addin - how to make visible in Macro menu? 2

Top