Assign shortcut keys

[mikeymay]

I have some buttons in a workbook which I would like to assign shortcut keys to.

For example - A button that navigates to the 'Home' sheet of the workbook, to which I would like to assign ALT+h


Thanks

 

[RoryA]

If it's a forms button, set the shortcut key for the macro. If ActiveX, set its Accelerator to h.

 

[mikeymay]

They are actually icons from google images and I'm not sure if it's ActiveX.

 

[RoryA]

If you assigned a macro to them, then just assign a shortcut key to the macro.

 

[mikeymay]

That's what I'm struggling to do. I can't find where to assign a specific key when assigning a macro to the icon

 

[RoryA]

You assign it to the macro in the options part of the Macros dialog.

 

[mikeymay]

Well you learn somethign new everyday......

Cheers Rorya