change a function key

[Billy]

Is it possible to change, or disable, a function key? I would like to
disable the F1 (Help) key, as I often accidently hit it while trying
to press F2. I know the best solution would be to NOT hit it
accidently, but I was just wondering if disabling or changing the
function keys is possible. I am using Excel 2002 on Windows XP
Profesional.

Tonso

 

[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

 

[Billy]

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

Thanks Dave...I will try the macro, and if not happy with that
solution, then i will just be more careful. [i do no think that
removing the key is good option]

Tonso

 

[Chip Pearson]

[i do no think that
removing the key is good option]

I've had the F1 key, the CAP LOCK key, and the NUM LOCK key removed from all
my keyboards on all my machines for many years and have never missed them.
Good riddance.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

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

Thanks Dave...I will try the macro, and if not happy with that
solution, then i will just be more careful. [i do no think that
removing the key is good option]

Tonso

 

[Dave Peterson]

I liked the line you used describing your keyboard--it looks like a hockey
player smiling.

[i do no think that
removing the key is good option]

I've had the F1 key, the CAP LOCK key, and the NUM LOCK key removed from all
my keyboards on all my machines for many years and have never missed them.
Good riddance.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

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

Billy wrote:

Is it possible to change, or disable, a function key? I would like to
disable the F1 (Help) key, as I often accidently hit it while trying
to press F2. I know the best solution would be to NOT hit it
accidently, but I was just wondering if disabling or changing the
function keys is possible. I am using Excel 2002 on Windows XP
Profesional.

Tonso

Thanks Dave...I will try the macro, and if not happy with that
solution, then i will just be more careful. [i do no think that
removing the key is good option]

Tonso