Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Toolbars for .xlam and .xlsm files

26 Jan 2014   #1

XP/7x32 & x64/8x64/8.1x64
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 **

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 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 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 SpecsSystem Spec

31 Jan 2014   #2

XP/7x32 & x64/8x64/8.1x64

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 complex
Converting 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.

Custom ribbon-tabs.
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 SpecsSystem Spec

 Toolbars for .xlam and .xlsm files

Thread Tools

Similar help and support threads
Thread Forum
I used to know the keystroke to turn on ms word 2007 toolbars but I forgot it. Can someone help? I promise I will record it this time!
Microsoft Office
Tons of files missing, desktop reset, browsers and toolbars reset...
Hello everyone, I'm kind of freaking out right now. I turned my computer off about 12 hours ago, and now that I turned it on again it took much longer than usual for it to prepare the desktop. When I got in, there are about 50 % of my desktop icons missing, the programs I had attached to the...
General Discussion
Toolbars, Menus, etc
Either with Win7 or with the latest version of programs, the top window row (above the menu), the menu, the toolbars and other items are all blended together. This makes it harder to figure out where what starts, where to grab the window, drag sections, etc. Of course I can see it but you need to...
General Discussion
All Files, Programs, Favorites, Toolbars Gone- Not a Virus
All was working properly when I turned off. In morning, I turned on and saw a HP screen, like when you first fire up a new computer. All programs were gone and files. It looked like a "new computer" and you had to install programs, etc. The Explorer opening screen was filled with Amazon,...
General Discussion
What files/folders keeps the Desktop Toolbars info ?
I have a consistent problem over time with my custom toolbars In Win 7 Pro 32bit. I have five custom toolbars : Graphics Design Quick Links Utilities Browsers If I change anything in the toolbars from time to time...the order functioning of the toolbars stays the same...but...the first...
I keep seeing everyone with a secondary tool bar (usually in the top middle of the screen) in screenshots. What are they and where can I get a good one that works with Win 7 Aeros?

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 07:19.

Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App