Excel 2007 has had much comment since its introduction, most
of which has been centred around the ribbon, is it a piece of inspired insight
by MS, or a blunder of enormous proportions? This post will not concern itself
over that issue directly, but will take a look at how some have addressed the
introduction of the ribbon, seeing product opportunity. I am referring of
course to the advent of various applications that provide the old 2003 style
menus within Excel.
Over the next few weeks I am going to look at a number of
these applications, cover their main functionality, and say what I think of
them. I have to start by declaring a prejudice against such aplications, as I
believe that if you want classic menus, why not use classic Excel? But of
course, some may want the 1M+ rows, I don’t but some may, and yet
still crave the old style menus, so I guess these products have a place. And of
course, it might help the transition to Excel 2007. Personally I think it is
like smoking, either give up or carry on, trying to do it by stealth is
The first Classic menu that I looked at was UBitMenu,
supplied by Ubit
Schweiz. This can be found at http://www.ubit.ch/software/ubitmenu-languages/
The price for UBitmenu is reasonable, free for private
use, and € 10 base fee + € 0.65 per user
for commercial use (+ VAT if applicable).
UBitMenu can be installed with standard user rights on any
Windows® Office 2007 / Office 2010 environment. The suppliers suggest that you
may need to save the file to a trusted location on your hard disk before you
run the setup. I had no need to do so.
The setup application installs UBitMenu
Excel, Word and PowerPoint. I had expected different menus for Excel
and Word and so on, but oddly on my system, the Word menu was the same
Excel menu. I don’t know if I did something incorrectly, not being a
big Word or PowerPoint user I was not too concerned with it. All changes are registered for uninstallation.
[Update – it has been pointed out to me that they are not the same, they are just very similar, which was a deliberate choice. My only excuse is that I saw things in Word that are not on my Word 2003 toolbars, such as the charting icon, but as Ubit Schweiz seem to have done this as something that would be value added for most users, and it is intended, I will stop digging and accept my fate].
UBitMenu is a simple Excel 2007 addin, with the menu items
defined in the CustomUI XML. You can view the XML using CustomUI, and can see
that it just invokes the builtin functions within Excel 2007.
When installed, there is a new ribbon tab added called Menu
(why not UBitMenu? [Update – I am told this is to restrict space encroachement in restricted situations, such as a laptop, which given the space grabbing proclivity of the Ribbon, I guess I should applaud this]) which looks like the classic Excel 2003 menu,
Standard and Formatting toolbars, with the Drawing toolbar thrown in
for good measure.
One aspect of the installation is unusual is that it installed
into my XLSTART directory, it did not give me the option to direct its
The tool is very simple to use, works well, and does exactly
what the suppliers suggest. It cannot be customised as Excel 2003 commandbars
can, it is simply a means to use a familiar format within an unfamiliar
environment, a transition tool until one is comfortable with the ribbon.
The suppliers suggest that you uninstall using the
‘Software’ applet in the Windows Control Panel, although as it is just an
addin, you can uninstall it using the Addins dialog, and then delete the file.
Any further selection in the addins dialog throws up a message that allows you
to remove it from the list.
This may be a good option for corporates that are looking to
install Excel 2007, but are concerned with the effect that the ribbon may have
on their user productivity, as it allows a smoother transition, at a small cost to the potential productivity loss. Its ease of deployment should not create any logistical problems.
A personal user may also find it useful in transitioning to Excel 2007, especially as it is free for personal use.
It is not for the power user who wants to continue
classic menus in an Excel 2007 world as it does not support commandbar
customisation. That would require delving into XML, which defeats the