Add the Classic Excel 2003 Menu to Excel 2007!
"You will have a classic mode, right?"- Bill Gates to Jensen Harris, after seeing the Office 2007 ribbon
Bill Gates was smart enough to see that Office 2007 needed a classic mode. But somehow, the Office development team convinced him that a classic mode wouldn't fit with the future direction of Office. So, we have a huge frustration point: Excel 2007 is the best new version of Excel in 10 years, but no one will upgrade because they don't want to re-learn the user interface. There are two products available that will add a classic menu back to Excel 2007. The first product to hit the market is the Classic Excel Menu product. It brings back all of the menu and toolbar options on a new tab in the ribbon. The product sells for $15.95 for an Excel version, or $29.95 in a version for Excel, PowerPoint, Outlook, Access and Word. The second new product is the Toolbar Toggle product. This utility sells for $29.95 and covers Word and Excel. While Classic Excel Menu will be sufficient for most people, the Toolbar Toggle product has extra bells and whistles that make it good for people who liked to customize their Excel 2003 toolbars. Classic Excel Menu
This was the first product to hit the market. Installation is simple. You are presented with an option to put the classic menus either first or last. An option allows you to add a new menu called All to the left of the File menu.
Once you install the add-in, simply launch Excel. Your ribbon will have a new tab called Menu. On the Menu tab, you will find the traditional File, Edit, View, Insert, Format, Tools, Data, Window and Help menu items. Two additional rows of icons mimic the Standard and Formatting toolbars. You will find that having the old menu system back has a very calming effect. Of course you can find the pivot table command - it is right on the Data menu where it has always been.
The Excel version is a 1.8MB download. The Office version is a 3.3 MB download. Starting October 14, 2007, the latest version will bring the classic menu back in any language that Excel supports. It also adds the new Excel 2007 functionality to the old menu. When I first saw Classic Excel Menu, I knew it was a product that everyone would like. I signed up to be able to resell the product here at MrExcel.com. You can buy the product and download it immediately from either of these links:
This product works for Word 2007 and Excel 2007. It does not (yet) support Power Point 2007. You are provided download files for both Toolbar Toggle Lite and Toolbar Toggle. The installation process is not quite as smooth as with the Classic Excel menu. Even though the files come as .exe files, they launch WinZip when opened, and I found myself having to unzip to a folder and then run the Setup.exe in order to install Toolbar Toggle Lite. The installation requires .NET Framework 2.0 so there were more files to download after launching the install. Even after installing Toolbar Toggle Lite, you are then required to go find a folder in program files and execute a .bat file. Toolbar Toggle Lite provides the entire menu on a new ribbon tab, just like Classic Excel Menu does.
The installation process for Toolbar Toggle was straightforward. No batch files to execute. Install the product and open Excel 2007. Initially, Excel will show the complete ribbon and then below that the Excel 2003 menu in a Toolbar Toggle region. This takes up a fair amount of real estate on the screen.
You will want to minimize the ribbon so that you can re-claim some of your lost real estate.
The place where Toolbar Toggle shines is that you can right-click the old menu, click Customize and then access a great version of the Excel 2003 Customize dialog box. Choose a category from the left side, then drag any menu item from the right side and drop it in any spot on the menu, just as you could do in Excel 97-2003. In the figure below, I've added the Close icon to the standard toolbar.
To buy Toolbar Toggle, follow this link: Buy ToolbarToggle - $19.95 Caveats
With both products, any use of the Alt keyboard shortcuts is going to access the Excel 2007 ribbon instead of the classic menu. If you are a keyboard shortcut person, you will find a little frustration with this. Recommendation
MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.
Excel is a registered trademark
of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.
All contents Copyright 1998-2008 by MrExcel Consulting.