XLA Unload problem

  • Thread starter Thread starter Von Shean
  • Start date Start date
V

Von Shean

I have to unload my XLA under some circumstances. I have tried the following
two ways.
1. MyXLA.Close
2. Application.AddIns("MyXLA").Installed = False

Both of these close the XLA but fail uncheck the Add-in checkbox in
Tools=>Add-in meni

Does anyone have a way to uncheck the add-in check box for an XLA who wants
to unload itself??
 
This works for me (for my Analysis Toolpack addin)
Application.AddIns(2).Installed = False

Rob
 

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

Back
Top