Removing An Item From The Addins Collection

Oddly, there is no direct way to remove an add-in from the Addlns collection. The Addlns collection does not have a Delete or Remove method. One way to remove an add-in from the Add-Ins dialog box is to edit the Windows Registry database (using regedit.exe). After you do this, the add-in will not appear in the Add-Ins dialog box the next time that you start Excel. Note that this method is not guaranteed to work with all add-in files.

Another way to remove an add-in from the Addlns collection is to delete, move, or rename its XLA file. You'll get a warning like the one in Figure 21-5 the next time that you try to install or uninstall the add-in, along with an opportunity to remove it from the Addlns collection.

Figure 21-5: One very direct way to remove a member of the Addlns collection.

Figure 21-5: One very direct way to remove a member of the Addlns collection.

0 0

Post a comment