New
#1
Toolbars for .xlam and .xlsm files
Over the years I have created about 40 addins in Excel 2003.
I cannot find how to modify my addins for Excel2007/2010 (in particular Excel 2010)
=====
EDIT 1-Feb-2014
- this post is tortuously long winded
- post #2 may help some users converting from Office 2003 to Office 2007/2010
- from the number of "lookers" there is considerable interest in 2007/2010 tabs/toolbars
** I will update this thread as I piece the process together **
GrayGhost2
=====
One, my precious "Global.xla" has 68 controls (menus and button) on it -- about 95% of "actions" are not bog-standard Excel commands.
In Excel 2003, my addins are sub-menus on the main Excel menubar.
Addin menus and controls are dynamic (ie, they are disabled/enabled depending on "selection", orphan workbooks etc.
All my addin menus are created at run-time as temporary controls, they expire when Excel close.
Excel 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.I have avoided giving up Excel 2003 but the bitter truth is biting me on the rear end.
I deleted the XLB and lost all customization of Standard and Formatting toolbar.
Since then I have written an XLS tool that rebuilds toolbars and context menus to my preferences.
Takes about 30 seconds to run, otherwise manually it would take me days.
So when XLB bloats, I just delete XLB and run my Rebuild_Toolbars.xls
(This has also made clean installing Windows less agony, as it is very quick to setup Excel.)
I have 5 other Excel 2003 rigs but number #6 died and I had to face upto Excel 2010.
Where can I go to learn how to programmatically add a menu to the Excel 2010 ribbon ?
In VBA it is very easy, but Excel 2010 does not use VBA to manipulate the ribbon.
I vaguely think I read several years ago that Ribbons are attached to files. Is this correct?
Currently child controls are endbaled/disabled with VBA, Will this work with ribbons or do I have to rewite the global project and all my other smaller Addins.
If you want to view my Global it is about 700KB, (that is after debloating with another tool I have written).
Just PM me I will gladly make it available, particularly if you can ease me into Excel 2010 coding.
I am considering using thrid party UBit or addintools "addons" to give me a Classic menubar.
But that structure may not be accessible to my VBA build menu on menubar.
After days of searching the web all I get is very beginner stuff for manually manipulating the ribbons with Excel commands. No help atall.
My Rebuild_Toolbars.xls customizes five Excel context menus, again to add some custom actions. Basically my context menu items are re-ordered, deleted and added to
A deparate ludite
I would appreciate any help or guidance
Last edited by bawldiggle; 31 Jan 2014 at 16:28.