....probably because it's close to F2

It's annoying because I don't want the help screen to appear and it takes
ages to load. I know the obvious solution is to stop pressing F1, but that's
just too simple, so I was wondering if there was a way to disable the F1 key?

Thanks

Rob

You have to use VB to reassign keys. Run the first sub to "fix" F1 and the
second to put it back if you want.

Sub KillHelp()
Application.OnKey "{F1}", ""
End Sub

Sub RestoreHelp()
Application.OnKey "{F1}"
End Sub


--
Jim
"Rob" wrote in message
...
| ...probably because it's close to F2
|
| It's annoying because I don't want the help screen to appear and it takes
| ages to load. I know the obvious solution is to stop pressing F1, but
that's
| just too simple, so I was wondering if there was a way to disable the F1
key?
|
| Thanks
|
| Rob

Thank you Jim.

I also just found on a google group, a suggestion from Chip Pearson to
physically remove the F1 key - which I thought was an excelent idea.
Unfortunatly it's not my keyboard so that might be frowned upon.

The OnKey method gets me half way, but I'm often already editing a cell when
I press F2. I don't think the OnKey method will work in this situation. Any
ideas?

Thanks
Rob




"Jim Rech" wrote:

You have to use VB to reassign keys. Run the first sub to "fix" F1 and the
second to put it back if you want.

Sub KillHelp()
Application.OnKey "{F1}", ""
End Sub

Sub RestoreHelp()
Application.OnKey "{F1}"
End Sub


--
Jim
"Rob" wrote in message
...
| ...probably because it's close to F2
|
| It's annoying because I don't want the help screen to appear and it takes
| ages to load. I know the obvious solution is to stop pressing F1, but
that's
| just too simple, so I was wondering if there was a way to disable the F1
key?
|
| Thanks
|
| Rob

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

Rob wrote:

...probably because it's close to F2

It's annoying because I don't want the help screen to appear and it takes
ages to load. I know the obvious solution is to stop pressing F1, but that's
just too simple, so I was wondering if there was a way to disable the F1 key?

Thanks

Rob

--

Dave Peterson

didn't try it, but check this and see if it will work

http://www.microsoft.com/downloads/d...DisplayLang=en

--


Gary


"Rob" wrote in message
...
...probably because it's close to F2

It's annoying because I don't want the help screen to appear and it takes
ages to load. I know the obvious solution is to stop pressing F1, but
that's
just too simple, so I was wondering if there was a way to disable the F1
key?

Thanks

Rob