如何从Excel工作簿中删除自定义工具栏？ [英] How do I remove a custom toolbar from an Excel workbook?

问题描述

我使用的是Excel 2007，而且我附带了一个带有自定义工具栏的Excel工作簿。每次打开工作簿时，工具栏都会显示在功能区的加载项下。我可以右键单击工具栏，然后选择删除自定义工具栏，并将其删除。但是当我重新打开工作簿时，它会重新出现。如何将其删除？

I'm using Excel 2007, and I have an Excel workbook with a custom toolbar attached. Every time I open the workbook, the toolbar appears on the ribbon under "Add-ins". I can right-click on the toolbar and choose Delete Custom Toolbar and that removes it. But when I re-open the workbook, it re-appears. How do I remove it for good?

工具栏不是由VBA创建的。它是使用 http ：//office.microsoft.com/en-us/excel/HP051986401033.aspx 。

The toolbar is not created by VBA. It was attached to the workbook in an earlier version of Excel using the steps outlined in http://office.microsoft.com/en-us/excel/HP051986401033.aspx.

推荐答案

我意识到这是一个古老的问题，但我刚刚发现一个简单的解决方案，在这里没有提到，将会用于未来的观众：

I realize this is an old question, but I just found an easy solution not mentioned on here that will be of use to future viewers:

1. 更改文件的扩展名为.zip


2. 打开存档


3. 删除 Attachedtoolbars.bin 文件从档案


4. 关闭存档


5. 将文件的扩展名更改回原来的

1. Change the file's extension to ".zip"
2. Open the archive
3. Delete the Attachedtoolbars.bin file from the archive
4. Close the archive
5. Change the file's extension back to what it was originally

这篇关于如何从Excel工作簿中删除自定义工具栏？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！