Check out the Onkey method, this re-purposes the built in Excel keys

Sub test()
'Re-puposes
Application.OnKey "^1", "MyCode"
End Sub

Sub myCode()
MsgBox "It ran with Ctrl+1"
End Sub


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Inspector" wrote in message
...
I have a macro that I would like to fire by hitting the 'Control 1' keys.
How do I begin?

Thanks