I keep hitting F1 by mistake

[Rob]

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

[Jim Rech]

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" <[email protected]> wrote in message
news:[email protected]...
| ...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

[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" <[email protected]> wrote in message
> news:[email protected]...
> | ...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]

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

[Gary Keramidas]

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

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

--


Gary


"Rob" <[email protected]> wrote in message
news:[email protected]...
> ...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