however, it seems that the icons there can't be changed which is a real
You can change the QAT images...
http://www.rondebruin.nl/imageqat.htm
Well, if you can run a macro here's a poor man's workaround. See the
Add-ins tab after running the first sub.
Sub AddXL2003WorksheetMenubar()
Dim NewCmdbar As CommandBar
Dim Cmd As CommandBarControl
DelXL2003WorksheetMenubar
Set NewCmdbar = CommandBars.Add("XL2003", , , True)
For Each Cmd In CommandBars("Worksheet menu bar").Controls
NewCmdbar.Controls.Add , Cmd.ID
Next
NewCmdbar.Visible = True
End Sub
Sub DelXL2003WorksheetMenubar()
On Error Resume Next
CommandBars("XL2003").Delete
End Sub
--
Jim
| Thanks! I suspected this but had to ask the question just in case.
|
| As for slowing things down, YOU BETCHA!!! The ribbon is even worse
| for the number of keystrokes needed to get things done than the old
| pulldowns. Sure it's graphical but the space it wastes at the top is
| tremendous! Yet there is no alternative to the ribbons that I can see
| like just the plain old pulldowns <sigh>. However, don't know all the
| ins and outs yet ...
|
| Re the speed, wow, that is just so wrong. When you develop a toolbar
| that has all the commands that you need during the average day, with
| the pulldowns picking up the slack for little-used commands, then
| one's speed is almost exponentially faster!
|
| But when editing a doct. I've come to see just how cumbersome the
| ribbon is since you have to tick to one place to change, say, fonts,
| and then someplace else to change, oh, I don't know, borders and then
| someplace yet again to do something else. And it's those endless
| mouse clicks that have always driven me nuts! And the pulldowns
| weren't grouped the way they are now.
|
| Also, the access to "classic" menu items, i.e., cell formatting where
| you can tab quickly between options, is even an _additional_ button
| away since I have to tell Excel to go to that.
|
| Nope. Not a happy camper here. This is a 2-steps back to go 1-step
| forward deal.
|
| But fortunately for me, I've regained a _small_ measure of speed by
| starting to put a few icons in the top "frequent need" tiny toolbar.
| Unfortunately for me, however, it seems that the icons there can't be
| changed which is a real bummer! I have customized toolbars for Excel,
| Word, WordPerfect and Outlook and a few other programs, that make my
| life so easy. I just replace the default templates that usu. house
| those toolbars and I'm up and running with my own customized system.
|
| One colleague a few years back even said my Word and WordPerfect
| interfaces looked like a cockpit there were so many buttons (not
| really since all the buttons served a quickly-accessible purpose
| [unlike the stupid ribbon <g>], so I got a laugh out of that.
|
| Part of the thing with my speed has to do with how I customize the
| programs I work with. To give an Excel example, let's say I need to
| do a bunch of things to a doct. To name 2 items - to change row
| height then set print area was just 2 clicks away only because those
| buttons are right there! Not so without my customized toolbar and
| with the ribbon.
|
| 'nuff said.
|
| Re the add-ins, that's _probably_ not going to be a viable solution
| since work computers are locked down so tight nowadays that they might
| not be possible to "install". I'll have to check it out. Perhaps
| there is something that will give me my speed back. I have no choice
| but to use Excel 2007 at the office since that is all that they have
| on offer here, but I can tell you, I certainly don't have to use it at
| home and will keep my version of Excel there!
|
| Thanks much.
D
|
|
| On Tue, 3 Jun 2008 09:43:17 -0400, "Jim Rech" <
[email protected]>
| wrote:
|
| >The XLB file just holds the customizations you've made to Excel
| >menus/toolbars so, even if you could open it in Excel 2007, it wouldn't
| >bring back any built-in menus, etc.
| >
| >There are add-ins and utilities that people have developed to create
| >"classic menus" in Excel 2007. If you search on that term and "Office
2007"
| >you'll find some. But I'm not sure it isn't wiser to bite the bullet and
| >learn to use the ribbon as I don't think it's going away. As for "so
slow"
| >I'm not sure what you mean. The ribbon has more graphics and it does
feel
| >slower but it's not slowing me down (other than having to hunt for
commands
| >during the learning phase).
| >
| >--
| >Jim
| >| >| Help! Any way to be able to use my Excel.xlb in the new Excel
| >| environment? Really don't like this new ribbon business as it's so
| >| SLOW!!! Worse than the old pulldowns used to be. Instead, I've been
| >| using my own toolbars that have practically everything I ever need
| >| right there on the main interface (one of the reasons I'm so fast!).
| >|
| >| I've googled but have found little help in this area. Hoping my
| >| Excel.xlb is more than total toast! <g>
| >
|
