Busgy,
Use the OnKey method. Run this once (perhaps put it in the Workbook_Open
handler or something):
Application.OnKey "{F9}", "MySub"
Now when F9 is pressed, it'll run MySub. Note that this is for any open
workbooks, not just the one that ran the macro. Also, it will remain in
effect when you close the workbook, and if F9 is pressed then, it'll reopen
the workbook containing MySub. You can reset the F9 key with:
Application.OnKey "{F9}", ""
which works nicely in the Workbook_BeforeClose event handler.
