Turn Off Help

[cr]

Does anyone know of a way to turn off the F1 key in
Excel2000? I can go to help the long way if I want it,
and I often find myself accidently hitting the F1 key and
having to wait for the help box to come up so that I can
quickly shut it down. I have a whole group of analyst
that would love to turn this off.

Any help would be greatly appreciated.

c-

 

[Lady Layla]

Pop the key off?


: Does anyone know of a way to turn off the F1 key in
: Excel2000? I can go to help the long way if I want it,
: and I often find myself accidently hitting the F1 key and
: having to wait for the help box to come up so that I can
: quickly shut it down. I have a whole group of analyst
: that would love to turn this off.
:
: Any help would be greatly appreciated.
:
: c-

 

[Dave Peterson]

Maybe you could a line or two to your personal.xls (auto_open/workbook_open
procedure):

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

If you pop the F1 key off, you may want to remove the spring and put the keytop
back. It'll look prettier!

 

[Guest]

As much as I liked the idea of just ripping the key off
(due to the fact that it stops future problems and feels
good from a revenge standpoing) I went with the VBA to run
with Auto_Open. Works like a charm.
Thanks

c-