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