Is it possible to press F4 to run a macro?

Or How can I assign a code on certain key?

Hi

All you need to do is setup the key probably on the Workbook_Open Event

there you could put the code

Application.OnKey {F4} , "MyMacroName"

this sets up when you press the F4 key it will run the Subroutine MyMacroName

in the Workbook_BeforeClose event use the code

Appliacation.OnKey {F4}

this stops the macro running everytime you press F4 if the Workbook isn't open

HTH

David

I tried it and it works perfectly!

thx