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

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
Reply

 Toolbars for .xlam and .xlsm files




Thread Tools



Similar help and support threads for2: Toolbars for .xlam and .xlsm files
Thread Forum
All Files, Programs, Favorites, Toolbars Gone- Not a Virus General Discussion
Solved Help With Unwanted Toolbars Performance & Maintenance
Solved What files/folders keeps the Desktop Toolbars info ? Customization
Solved Toolbars Customization
Custom Toolbars? Customization

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 01:49 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33