XL2002: Automation Add-In Still Loaded After Add-In Check Box Cleared (283668)


The information in this article applies to:

  • Microsoft Excel 2002
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, 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 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:
  1. If Excel is currently running, quit Excel.
  2. Click Start, and then click Run.
  3. In the Open box, type regsvr32 /u path/file name, where path/file name is the full path and file name of the add-in that you want to remove. For example, type the following:

    regsvr32 /u "C:\Windows\Application Data\Microsoft\AddIns\MyAutomationAddIn.dll"

  4. Click OK.
  5. Click OK when you receive the following or similar message:
    DllUnregisterServer in C:\Windows\Application Data\Microsoft\AddIns\MyAutomationAddIn.dll succeeded.
  6. Start Microsoft Excel.
  7. On the Tools menu, click Add-Ins.
  8. Click to clear the check box next to the add-in.

    NOTE: If the check box is already cleared, click to select it.
  9. Click Yes when you receive the following or 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.

REFERENCES

For more information about add-ins, click Microsoft Excel Help on the Help menu, type about add-in programs in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For additional information about how to create an automation add-in, click the article number below to view the article in the Microsoft Knowledge Base:

285337 HOWTO: Create a Visual Basic Automation Add-in for Excel 2002 Worksheet Functions

Modification Type:MajorLast Reviewed:8/6/2002
Keywords:kbprb KB283668
©2002 Microsoft Corporation. All rights reserved.