Add-In modules vs Code Modules

[JenniferMurphy]

Is there a way to have an add-in module deactivated for one workbook, but still active for all other workbooks?

The only way I know of to deactivate an add-in is File | Options | Add-Ins | Manage | uncheck the add-in in the list. This procedure causes that add-in to unchecked for all workbooks.

I am trying to convert a workbook from one that uses code in an add-in to a self-contained workbook that I can send to someone else without sending the add-in. I am doing this by copying all of the functions that it uses from the add-in to a code module in the workbook. While I am doing it, which may involve some testing, it would be handy to have the add-in active for any other workbooks that I may have open so they are still functional.

Thanks

 

[shg]

If you're using UDFs, Excel will preferentially use the local one rather than one by the same name in an add-in.

 

[Yongle]

To Unload AddIn

AddIns("Name of AddIn").Installed = False

To Load AddIn when required

AddIns("Name of AddIn").Installed = True

Suggest you try calling above from workbook event macros
(which should be placed in the workbook where the AddIn is to be disabled)

call unload from
Workbook_Open
Workbook_Activate

call load from
Workbook_BeforeClose
Workbook_Deactivate

Perhaps a single procedure like this

Sub LoadAddins(TrueFalse As Boolean)
    AddIns("Name of AddIn").Installed = TrueFalse
End Sub

Load with

Call LoadAddins(True)

Unload with

Call LoadAddins(False)

 

[JenniferMurphy]

If you're using UDFs, Excel will preferentially use the local one rather than one by the same name in an add-in.

I sorta knew that, but remembered having some problems being sure that it worked that way. Thanks for the confirmation.

 

[JenniferMurphy]

To Unload AddIn

AddIns("Name of AddIn").Installed = False

To Load AddIn when required

AddIns("Name of AddIn").Installed = True

Suggest you try calling above from workbook event macros
(which should be placed in the workbook where the AddIn is to be disabled)

call unload from
Workbook_Open
Workbook_Activate

call load from
Workbook_BeforeClose
Workbook_Deactivate

Perhaps a single procedure like this

Sub LoadAddins(TrueFalse As Boolean)
    AddIns("Name of AddIn").Installed = TrueFalse
End Sub

Load with

Call LoadAddins(True)

Unload with

Call LoadAddins(False)

Thank you very much for this. I will give it a try.