Deactivating the F1 key

[Azhar Moinuddin]

I work extensively on Excel. While using the F2 edit key,
I accidently press the F1 key and suddenly the help starts
when it is not needed. This takes quite some time off
since help loads slowly. Is there a way i can deactivate
my F1 key or assign another function key for help ?

Thanks

 

[Dave Peterson]

Maybe you could a line or two to your personal.xls (auto_open/workbook_open
procedure):

Option Explicit
Sub disableF1()
Application.OnKey "{f1}", ""
End Sub
Sub enableF1()
Application.OnKey "{f1}"
End Sub

There's at least one person who removes the keys he doesn't like (Hi, Chip!).
You may want to pop the key off and take out that little springy thing. And
then use the Help from the menu.