Custom shortcuts

[Stevenn]

I've customized the ribbon in my workbook in Excel 2007. Is it possible to make custom keyboard shortcuts to the procedures?

My procedures look like

Public Sub ProcedureName(control As IRibbonControl)
End Sub

 

[RoryA]

A simple way is to have the ribbon callbacks simply call normal macros and you can then assign shortcuts to those macros as normal. Alternatively, using the Alt key, you can navigate to your controls just like any other on the Ribbon, though the shortcuts might not be as short as you'd like.

 

[Stevenn]

A simple way is to have the ribbon callbacks simply call normal macros and you can then assign shortcuts to those macros as normal. Alternatively, using the Alt key, you can navigate to your controls just like any other on the Ribbon, though the shortcuts might not be as short as you'd like.

Thank you. I will use your first mentioned solution