How to apply Application.OnKey

[dewanna]

Hello there...

I'd like to ask anyone here regarding the above title. I tried it for so many times based on an example from Excel help but yet it doesn't show me anything difference. Any suggestion pls... Thanks in advance.

[Carim]

Hi Dewanna,

Always be careful with this instruction which changes the normal
behaviour of a given key ...
To have the F1 key execute your macro :
Application.OnKey "{F1}", "YourMacro"
To have the F1 key back to normal :
Application.OnKey "{F1}"

HTH
Carim