Rabu, 26 November 2014

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 -----
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, <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
Version: 2015.0.5577 / Virus Database: 4223/8632 - Release Date: 11/25/14


Posted by: "David Smart" <smartware.consulting@gmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)
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