Microsoft KB Archive/283668

= Automation add-in still loaded after add-in check box cleared =

Article ID: 283668

Article Last Modified on 6/1/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q283668





SYMPTOMS
After you clear the check box for an Automation add-in in the Add-Ins dialog box in Microsoft Excel, the user-defined functions in that add-in continue to work.

There is no way to remove an Automation add-in from the Automation Servers dialog box.



CAUSE
When you cancel the selection of an Automation add-in, the add-in is still registered with the operating system. User-defined functions in the add-in change to include the Program ID and continue to calculate properly.

For example, assume that the following conditions are true:
 * The Automation add-in has a Program ID of Project1.Class1.
 * The Automation add-in contains a user-defined function called MyFunc.
 * A cell on the worksheet contains =MyFunc.

If you clear the check box for the Automation add-in in the Add-Ins dialog box, the MyFunc function continues to calculate properly, and appears in the worksheet as =Project1.Class1.MyFunc.



RESOLUTION
To completely remove the Automation add-in, follow these steps:  If Excel is currently running, quit Excel. Click Start, and then click Run. In the Open box, type regsvr32 /u, where   is the full path and file name of the add-in that you want to remove. For example, type the following:

regsvr32 /u &quot;C:\Windows\Application Data\Microsoft\AddIns\MyAutomationAddIn.dll&quot;

 Click OK. Click OK when you receive the following or similar message:

DllUnregisterServer in C:\Windows\Application Data\Microsoft\AddIns\MyAutomationAddIn.dll succeeded.

 Start Excel.</li> On the Tools menu, click Add-Ins.</li> Click to clear the check box next to the add-in.

NOTE: If the check box is already cleared, click to select it.</li> Click Yes when you receive the following error message or a similar message:

Cannot find add-in. Delete from list?

NOTE: Although the add-in is no longer attached to Excel, the file for the add-in is still on the hard disk.</li></ol>

<div class="references_section">