close

I use the lt;F2gt; key constantly to enter the edit mode and sometimes I
accidentally hit the lt;F1gt; instead, starting Excel's help feature. Can I make
it stop?

Chip Pearson says that he actually quot;fixedquot; 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 quot;{f1}quot;, quot;quot;
End Sub

This would toggle it back to normal.

Sub enableF1()
Application.OnKey quot;{f1}quot;
End Sub

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

sonic_d_hog wrote:
gt;
gt; I use the lt;F2gt; key constantly to enter the edit mode and sometimes I
gt; accidentally hit the lt;F1gt; instead, starting Excel's help feature. Can I make
gt; it stop?

--

Dave Peterson

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()