Hot Key
 

Hey
Does anyone know how I can assign a macro be performed when F9 is
clicked ?


--
Bugsy
------------------------------------------------------------------------
Bugsy's Profile: http://www.excelforum.com/member.php...o&userid=24300
View this thread: http://www.excelforum.com/showthread...hreadid=379060

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.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Bugsy" wrote in
message ...

Hey
Does anyone know how I can assign a macro be performed when F9 is
clicked ?


--
Bugsy
------------------------------------------------------------------------
Bugsy's Profile:
http://www.excelforum.com/member.php...o&userid=24300
View this thread: http://www.excelforum.com/showthread...hreadid=379060