peltier tech utilities
Learn how to create Excel dashboards.

Categories

30 Excel Functions in 30 Days

Archives

Delete Custom Toolbar from Excel Ribbon

In Excel 2003, you could create a custom toolbar, and attach it to a specific workbook. I didn't use that feature, but occasionally I receive a workbook where someone has attached a toolbar.


CustomToolbars00


Custom Toolbars in Excel 2007


The Ribbon was introduced in Excel 2007, to replace the Excel toolbars. It has an Add-Ins tab, where custom toolbars and menu commands will appear.


CustomToolbars01


If you open an Excel 2003 workbook that has an attached custom toolbar, that custom toolbar's tools will appear on the Add-Ins tab in the Ribbon. Things can get pretty messy, especially if those custom toolbars had more than a few buttons.


Here's just a small section of my Add-Ins tab, after opening a client's workbook.


CustomToolbars03


Delete a Custom Toolbar from the Ribbon


Unfortunately, those custom toolbars don't automatically disappear when you close the workbook to which they're attached. Nope, they hang around, uninvited, cluttering up the place.


The good news is that you can delete the custom toolbars from the Ribbon, with an easy mouse shortcut.


To delete a custom toolbar from the Ribbon:



  • Right-click on one of the custom toolbar's commands
  • Click Delete Custom Toolbar

CustomToolbars02



  • When the warning message appears, click Yes, to confirm that you want to delete the custom toolbar.

CustomToolbars04


And don't worry -- you're not deleting the toolbar from the workbook. It will turn up again, whether you want it or not, the next time you open that workbook.


Watch the Remove Custom Toolbars Video


This Excel video tutorial will show you how to remove any custom toolbars from the Ribbon, by using a mouse shortcut.









_______________

Related Posts Plugin for WordPress, Blogger...

3 comments to Delete Custom Toolbar from Excel Ribbon

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>