Excel 2007 : How Do I Delete worksheet embedded toolbars in Excel 2007?

[ALF-E]

I've recently converted to Excel 2007 from Excel 2003. In Excel 2003 I had an xls file with an embedded toolbar with buttons to execute macros. I've since converted this file to an Excel 2007 xlsx file; however, I've been unable to stop the toolbar buttons from being created under the Add-Ins ribbon. I've deleted the custom toolbar numerous time and resaved the file but when I reopen the file the toolbar comes right back. Please help me get rid of this pesky custom toolbar.

[Justin Young]

Good question! The following code solves your problem by removing the toolbar each time the workbook opens but I would love to know if there is a way to actually delete the attached toolbar forever.

The following solution assumes that your custom toolbar is called CustomToolbar. You need to find out the name of the toolbar that is attached before you can implement this solution.

1. Open the workbook that contains the custom toolbar.
2. Press ALT+F11 to switch to the Visual Basic Editor
3. In the explorer bar to the left of the screen, locate the VBA project that corresponds to the workbook and double click on the ThisWorkbook code module.
4. Choose Workbook from the object drop down at the top left of the code module.
5. Enter the following code.

Please Login or Register  to view this content.

The final result should appear as shown below:

Please Login or Register  to view this content.

Save the workbook as an xlsm - a macro enabled workbook. Each time you open the workbook Excel will delete the custom toolbar.

[ALF-E]

Thanks for the reply Justin; however, this doesn't solve my problem. For this to work it would have to be executed everytime I open the workbook. The attached commandbar I have is causing an error when loading my file. Error: "Excel cannot complete this task with the available resources.
Choose less data or close other applications."
If I can find a way to rid the file of the attached commandbar/custom toolbar, this error should go away. If you run across anything, please post again.