Rabu, 26 November 2014

RE: [ExcelVBA] Please take my Poll


I appreciate your hesitation. I was whining into the Ribbon, too. And I still use 2003 to find some stuff when I forget where on the Ribbon it might be located. But YES!!! Nearly ALL the keyboard shortcuts from menu versions work in the ribbon version. They don't tell you that they do…but they do! The ribbon has NEW shortcuts…so to speak. If you hit the alt key, they show up. But they're not as good as the menu shortcuts. But yes, again, I often tell users that if you were a shortcut user in menu version…you have an advantage to mousers cos' you can find your commands faster by just using the old shortcuts versus having to hunt for familiar commands via the mouse! ;-)

Dian D. Chapman

Technical Consultant & Microsoft MVP, MOS Certified Instructor,

Editor/TechTrax Ezine, Technical Editor/Word & Office 2007 Bibles

<https://mvp.support.microsoft.com/en-us/mvp/Dian%20D.%20Chapman-7288> https://mvp.support.microsoft.com/en-us/mvp/Dian%20D.%20Chapman-7288

Dian's Soldiers' Site

<http://www.mousetrax.com/Angels> http://www.mousetrax.com/Angels

From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com]
Sent: Wednesday, November 26, 2014 3:31 PM
To: ExcelVBA@yahoogroups.com
Subject: Re: [ExcelVBA] Please take my Poll

Thanks for the thanks.

Actually, I use shortcut keys quite a fair bit, instead of either. E.g. conditional formatting is Alt-O-D to me, and I never use the mouse at all to select it. (I have just noticed that conditional formatting is the most prominent button on the Home ribbon, so it's actually easier to use the mouse on the ribbon than on the menu for that one. :-) But easier still to use the keyboard, IMO.)

So out of curiosity I looked at the screen to see what happens while I type the shortcut ... a little pop-up appears saying "Office 2003 menu access key Alt, O". So, MS do somewhat still acknowledge the old menu system. :-)

I had supposed that a problem with the ribbon system was that people who like to use keyboard shortcuts don't get "training" on what the "menu" shortcuts are. But that's not correct. When I press and release Alt, it goes into a mode where it displays the shortcut keys on the ribbon itself - with keys for everything!! Just need to learn hundreds of sequences, and I can continue to ignore the ribbon. :-)

(More specifically, if I Alt-P to bring up the Page Layout ribbon, for example, then I get all the following shortcut keys in little pop-ups. That's decidedly clever, and maybe I'll learn the ribbon eventually, Dian.)

Regards, Dave S

----- Original Message -----

From: h_dunbar@hotmail.com [ExcelVBA] <mailto:h_dunbar@hotmail.com%20[ExcelVBA]>

To: ExcelVBA@yahoogroups.com <mailto:ExcelVBA@yahoogroups.com>

Sent: Thursday, November 27, 2014 3:30 AM

Subject: Re: [ExcelVBA] Please take my Poll

David, thanks for posting that. If someone as fluent and capable as you still prefers to work with menus rather than ribbons, it makes me feel less of a die-hard myself!

Best, Dunbar

---In ExcelVBA@yahoogroups.com <mailto:ExcelVBA@yahoogroups.com> , <smartware.consulting@...> wrote :

Hi Dian

I've responded to your poll, but more info:

> ... and how many are still using menu versions.

I've just installed 2007 on my primary PC (with 2003 still on the others).

The first thing I did was to find an addin that gave me back the menus. :-)

Maybe I'll get used to the ribbons eventually.

Regards, Dave S

No virus found in this message.
Checked by AVG - www.avg.com <http://www.avg.com>
Version: 2015.0.5577 / Virus Database: 4223/8632 - Release Date: 11/25/14


No virus found in this message.
Checked by AVG - www.avg.com <http://www.avg.com>
Version: 2015.0.5577 / Virus Database: 4223/8633 - Release Date: 11/26/14

No virus found in this message.
Checked by AVG - www.avg.com <http://www.avg.com>
Version: 2015.0.5577 / Virus Database: 4223/8633 - Release Date: 11/26/14

[Non-text portions of this message have been removed]


Posted by: "Dian Chapman" <dian@mousetrax.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

Visit our ExcelVBA group home page for more info and support files:

More free tutorials and resources available at:




Tidak ada komentar:

Posting Komentar