How can I disable Help in Excel (especially the <F1> key)?

S

sonic_d_hog

I use the <F2> key constantly to enter the edit mode and sometimes I
accidentally hit the <F1> instead, starting Excel's help feature. Can I make
it stop?
 
D

Dave Peterson

Chip Pearson says that he actually "fixed" his keyboard by taking that key off.
Others say that they left the key, but removed the spring underneath.

But you could use a couple of macros (one to disable and one to enable):

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

This would toggle it back to normal.

Sub enableF1()
Application.OnKey "{f1}"
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top