Microsoft Office Tutorials and References
In Depth Information
Removing an Add-In from the Add-Ins List
rEMoVing An Add-in froM THE Add-ins lisT
At some point in the future, you might want to remove the add-in from the list of available add-ins
in the Add-Ins dialog box, if the add-in is outdated or you just don’t need it anymore. To accomplish
this is an example of how science meets art, because Excel does not have a built-in way to remove an
add-in’s name from the list. Here are the steps to make this happen:
Open Windows Explorer and navigate to the folder
that holds your add-in file.
Select the add-in filename, and without opening the
file, either change its name, or drag the file to a
different folder, or, if you really no longer need the
add-in, delete the file altogether.
Open Excel, and when you do, you’ll receive a
message telling you that the add-in file cannot be found.
Click the OK button as indicated in Figure 22-15.
Open the Add-Ins dialog box and uncheck the name of the
add-in you want to remove. Excel reminds you that the file
cannot be found, and asks for confirmation that you want to
delete the file from the list of available add-ins. Click the Yes
button as indicated in Figure 22-16.
In this lesson, you create and install an add-in that contains a User Defined Function to return the
text of another cell’s comment.
For this lesson, you create an add-in to return the text of comments in other cells, and you test the
add-in by installing it onto a workbook that has comments in worksheet cells. To get the sample
Open a new workbook.
Go to the Properties window. In the Title field enter Comment Text and in the Comments
field enter Return text of comments in other cells .
Exit the Properties window and press the Alt+F11 keys to go into the Visual Basic Editor.