Turn Off Help

C

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-
 
L

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-
 
D

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!
 
G

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-
 

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