How to disable help from appearing when pressing F1

D

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.
[email protected]
 
J

John Wilson

Drew,

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

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

John
 
Top