How to apply Application.OnKey
 

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.


--
dewanna
------------------------------------------------------------------------
dewanna's Profile: http://www.excelforum.com/member.php...o&userid=32943
View this thread: http://www.excelforum.com/showthread...hreadid=530796

How to apply Application.OnKey
 

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