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
- Jul 16 Mon 2007 20:38
How can I disable Help in Excel (especially the lt;F1gt; key)?
close
全站熱搜
留言列表
發表留言