|26 Jan 2014||#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)
- 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 **
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 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
|My System Specs|
|31 Jan 2014||#2|
| || |
No takers ?
Maybe my initial post was ... tooo loonngg
I think I can answer most of my own question now, after 5 days of searching. For the benefit of any other user of Office 2010, particularly Excel 2007/2010
MS Word 2003 had (has) dedicated toolbars for .dot and .doc documents.
I had forgotten how sensible that was and the nagging question why not the same for Excel 2003 ?
Now Excel 2010 has similar structure under the ribbon. An excellent improvement for all Excel users + VBA coders including custom toolbars.
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 ... was very complexConverting 2003 addins to 2010 ?
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.
Require XML -- there are several third party programs used to setup custom ribbon-tabs, using XML language. At a glance the available programs look promising. -- many free and some commercial.
RibbonX (endorsed by Microsoft) is one of the freebies but it is not suited for Office 64-bit.
There are some excellent tutorials/utube on the web. " Ron de Bruin" (Microsoft MVP) is well worth a google.
As I learn more I will get back to this thread ...
|My System Specs|
|Similar help and support threads for2: Toolbars for .xlam and .xlsm files|
|All Files, Programs, Favorites, Toolbars Gone- Not a Virus||General Discussion|
|Help With Unwanted Toolbars||Performance & Maintenance|
|What files/folders keeps the Desktop Toolbars info ?||Customization|
|Our Sites ||Site Links ||About Us ||Find Us |
© Designer Media Ltd
All times are GMT -5. The time now is 05:29 PM.