Excel 2003 toolbars in Excel 2007

  • Thread starter Thread starter Helge V. Larsen
  • Start date Start date
H

Helge V. Larsen

I have used Excel 2003 for years and have made a rather heavy customization
by defining new toolbars with buttons calling VBA. Unfortunately, with Excel
2007 toolbars no longer exist! Gates and his gang of developers have decided
that we all have to use Ribbon instead. Ofcourse I could write a lot of XML
using the Custom UI Editor
(http://openxmldeveloper.org/articles...muieditor.aspx) to put my
customization into the Ribbon - but I still prefer toolbars.

I know of two utilities that introduce toolbars in Excel 2007: ToolbarToggle
(http://www.toolbartoggle.com) and Classic Menu for Excel 2007
(http://www.addintools.com/english/menuexcel). As far as I can see, only
ToolbarToggle supports toolbar customization.

Does anyone know other - and perhaps better - toolbar utilities for Excel
2007?

(This has also been posted to http://www.mrexcel.com/forum in forum 'Excel
Questions' and to http://www.excelforum.com in forum 'Excel 2007 Help'.)
 
I'm not sure how you create the new toolbars (via code or manually creating and
attaching them to workbooks???).

But I use code to create my toolbars. And when I do that, the toolbars show up
under the Addins tab on the xl2007 ribbon. (Someday, I'll bite the bullet and
create a ribbon version--real soon <vbg>.)

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)
 
 
After comparing the tools mentioned in my original post and in posts from
Dave Peterson, Shane Devenshire and 2007FanFoe (thanks to all) I think that
ToolbarToggle is best suited for me:
It does NOT integrate 2003-toolbars into the 2007-Ribbon. Instead
ToolbarToggle creates its own menu bar and toolbars.
The user can have Ribbon or toolbars or both displayed - and most important
to me: ToolbarToggle's menus and toolbars can be customized calling my own
VBA.
 
Back
Top