Ctrl+Alt to assign macros in Excel? 1

[DrSimon]

Dear All
I've read thread68-1305138 but just want to make sure that I'm not missing something. I like using keyboard shortcuts in Word and have just found that Excel is very limited in this respect. Can I really only assign using 'Ctrl+'? There's far more flexibility in Word and what's more Keybindings property is available in VBA.

If all that is the case, is there any way (short of using the 'Keyboard shortcuts in Excel 2010' in help) for me to determine what keyboard shortcuts are in use before overwriting (I can write VBA if necessary)?
Thanks in advance

 

[GlennUK]

You can assign keyboard shortcuts to Ctrl+Alt+whatever within VBA using the Application.OnKey command.

Does that help?

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[DrSimon]

Yes that's great Glenn - Many thanks.
Any ideas about my second question - the existing contents of such shortcuts? I've had a look round using the word 'Key' as index, but
no luck.
Simon

 

[GlennUK]

Glad to have helped with the first question.

As for the second question, no, no ideas for that, other than looking at the help ... I don't know of any automated way of finding out what native Excel shortcuts are in place. Good news is that I think that there's only 2 native Ctrl-Alt-whatever shortcut in Excel 2010 -

CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.

CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.

According to this tipcard:

http://officeimg.vo.msecnd.net/en-us/files/680/886/AF102692107.pdf

...

The CTRL combinations CTRL+E, CTRL+J, CTRL+M, and CTRL+Q are currently unassigned shortcuts.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[DrSimon]

Thanks Glenn - have a star!
I'll post this on the VBA forum later and see if anybody has an idea.
Simon