Keybindings Collection in Excel

[John]

Hi,

Can anyone tell me how to assign short cut keys to macros (other than the
manual method). I'm trying to program a set of programable keys
(www.x-keys.com) to fire a macro.

I've discovered the "Keybindings" collection in Word, but it doesn't appear
to exist in Excel. Is there an alternative?

Lastly are normally set macro short cut key combinations stored in the
respective document or somewhere else?

Thanks in advance

John

 

[Chip Pearson]

John,

You can use the OnKey method of the Application object to assign
a macro to a key combination . See OnKey help in VBA help for
more details.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com