Assign macro key to Excell Add-In macro?

[Bossk128]

I'm trying to assign a keyboard shortcut to a macro in an Excel add-in. Excel doesn't have the "customize menu AND KEYBOARD" dialog in the Ribbon settings.

So going back to good old Alt shortcuts, I'm nearly there. However I can't see which key to press for the last step, it's Alt, X, Y5. what they heck is key Y5??

 

[andshrew]

I think it means you press Y followed by either 1, 2, or 3 etc.

 

[Bossk128]

I feel like such a nob. I'm sure I tried that....

Anyway, exactly right andshrew, that works.

Cheers!