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.
Is the ToolBar created using code?
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
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.
Last edited by crawding; 08-17-2011 at 03:07 PM. Reason: Clarify my response.
Try this
View -> Toolbars -> Customize -> Reset
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
[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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks