How to disable help from appearing when pressing F1

[Drew Paik]

One of my greatest pet peeves about Office (but
especially Excel) is the F1 key. I use F2 a lot in Excel
to edit a cell, and sometimes I accidentally press F1,
which causes my system to pause while the gigantic help
file is loaded.

If I want help, I just want it to show when I use the
drop-down menus. Is there any way to disable F1?

Drew.
(e-mail address removed)

 

[John Wilson]

Drew,

For a particular workbook, you could disable it with a macro:

Private Sub Workbook_Open()
Application.OnKey "{F1}", ""
End Sub

John