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

"Von Shean" wrote in message
...
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??