How to redirct F1 to bring my Help

[Ben]

Hi,
How can I redirect F1, when the user press F1 0n an
active worksheet I can display my Help.
I trayed to changed the Help file name in the VBAProject
properties but when I press F1 the help of excel is
displayed.

Thank you.

 

[Harald Staff]

Hi

One way;

Sub RedirectF1()
Application.OnKey ("{F1}"), "myHelp"
End Sub

Sub myHelp()
MsgBox "You broke it, you fix it."
End Sub

HTH. Best wishes Harald

 

[Ben]

Thank you it work.