vba 如何在不重命名或删除 xla 文件的情况下从 xls 中删除 xla？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/700985/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to remove xla from xls without renaming or deleting xla file?
提问by adolf garlic
I need to get rid of an XLA (excel add-in) from a spreadsheet, but everything on the web seems to point to renaming/deleting the xla file.
我需要从电子表格中删除 XLA（excel 加载项），但网络上的所有内容似乎都指向重命名/删除 xla 文件。
This is not an option as the xla file is used by many other spreadsheets and is on a shared drive.
这不是一个选项，因为 xla 文件被许多其他电子表格使用并且位于共享驱动器上。
Are there any other alternatives?
还有其他选择吗？
回答by adolf garlic
I copied all the classes and modules (drag and drop) from the xla to the 'local' project.
我将所有类和模块（拖放）从 xla 复制到“本地”项目。
Save and close xls
保存并关闭 xls
I searched for the xla project name in the registry (with excel closed) and deleted the value.
我在注册表中搜索了 xla 项目名称（关闭了 excel）并删除了该值。
Open excel
打开excel
Done
完毕
回答by Eugene Wang
Move or rename the .xla file, then go to add-in manager. select the add-in, and click "delete" on the pop-up massage.
移动或重命名 .xla 文件，然后转到加载项管理器。选择加载项，然后在弹出的按摩中单击“删除”。
回答by Dick Kusleika
Do you mean you want to remove it from the add-in dialog box? Disconnect from the shared drive, load Excel, and try to install the add-in. Excel will tell you it can't find it and ask if you want to remove it. Once you've removed it, reconnect to the shared drive.
您的意思是要将其从加载项对话框中删除吗？断开与共享驱动器的连接，加载 Excel，然后尝试安装加载项。Excel 会告诉您它找不到它并询问您是否要删除它。删除后，重新连接到共享驱动器。
回答by Martin
If I understand your question, the solution might be:
如果我理解您的问题，解决方案可能是：
- On the Tools menu, click Add-Ins.
- In the Add-Ins available box, clear the check box next to the add-in you want to unload, and then click OK.
- 在工具菜单上，单击加载项。
- 在“可用加载项”框中，清除要卸载的加载项旁边的复选框，然后单击“确定”。
Source: http://office.microsoft.com/en-us/excel/HP052037321033.aspx
来源：http: //office.microsoft.com/en-us/excel/HP052037321033.aspx
