Delete Custom Toolbar

**crawding** · 08-17-2011, 12:22 PM

How do I permenantly delete a no longer wanted Custom Tool Bar?
I am using Excel 2003 and recently updated an Add-In to include an additional function and modified the associated Custom Tool Bar to include a button to invoke the new feature. Alas, every thing I have tried to delete the previous Custom Tool Bar has been futile. The Customize/Toolbars/Delete only eliminates the previous toolbar for that session of Excel. However when I reopen Excel it is redisplayed. I checked the .XLB file update date and verified that it is being written upon Excel closure.

**royUK** · 08-17-2011, 02:34 PM

Is the ToolBar created using code?

**crawding** · 08-17-2011, 02:55 PM

Re your question "Is the ToolBar created using code?" The answer is no. The unwanted Custom Tool Bar is some how attached to the .XLA file which contains macros. The macros have no code to create the Custom Toolbar. I just added Private Sub Workbook_Open() code to the ThisWorkBookXLA file " Application.CommandBars("Name of Old ToolBar").Delete" and that deletes the CustomToolBar upon opening of Excel. I am looking for a method to delete in a manner where it is no longer "attached" or what ever to the .XLA file.

Thanks much for your response.

**royUK** · 08-18-2011, 02:31 AM

Try this

View -> Toolbars -> Customize -> Reset

**crawding** · 08-18-2011, 10:43 AM

[QUOTE=royUK;2582285]Try this

I tried View -> Toolbars -> Customize -> Reset . The Custom Toolbar still reappears when Excel is opened. Does "Reset" only work on the "Standard" toolbar?

After much futile searching I have decided to use a work around for now. One of the original original Custom Toolbar buttons now calls a macro containing a Message Box which allows the user to select which one of two functions they want to run. Actually a bad intuitive solution as the two functions both relate to Time.

Thanks again royUK for your interest and help