Require XML - there are several third party programs used to setup custom ribbon-tabs, using XML language. In Excel 2010 - I can dump a lot of the UI, foreign-workbook, toolbar-management, shortcut-keys-management - because of the new Excel 2010 structure.

The amount of code that had to written in Excel 2003 to manage empty UI - wrong workbook - hiding/showing custom toolbars - enabling/disabling shortcut keys. An excellent improvement for all Excel users + VBA coders including custom toolbars. Now Excel 2010 has similar structure under the ribbon. I had forgotten how sensible that was and the nagging question why not the same for Excel 2003 ? MS Word 2003 had (has) dedicated toolbars for. For the benefit of any other user of Office 2010, particularly Excel 2007/2010 I think I can answer most of my own question now, after 5 days of searching. (This has also made clean installing Windows less agony, as it is very quick to setup Excel.)I h. So when XLB bloats, I just delete XLB and run my Rebuild_Toolbars.xls Takes about 30 seconds to run, otherwise manually it would take me days. Since then I have written an XLS tool that rebuilds toolbars and context menus to my preferences. I deleted the XLB and lost all customization of Standard and Formatting toolbar. In Excel 2003, my addins are sub-menus on the main Excel menubar.Īddin menus and controls are dynamic (ie, they are disabled/enabled depending on 'selection', orphan workbooks etc.Īll my addin menus are created at run-time as temporary controls, they expire when Excel close.Įxcel 2003 XLB file is notorious for bloat, if a toolbar is manually created then deleted.About 12 years ago my XLB file reached 8GB, opening Excel was horrendously slow.

One, my precious 'Global.xla' has 68 controls (menus and button) on it - about 95% of 'actions' are not bog-standard Excel commands.

** I will update this thread as I piece the process together **

from the number of 'lookers' there is considerable interest in 2007/2010 tabs/toolbars post #2 may help some users converting from Office 2003 to Office 2007/2010 I cannot find how to modify my addins for Excel2007/2010 (in particular Excel 2010) Over the years I have created about 40 addins in Excel 2003.

Atpvbaen.xlam excel 2016 for mac