I now know how to turn it of in Word, but it is a real pain in Excel when it
keeps popping up when I want the F2 key or escape key. I use too many
different keyboards and am not in the habit or looking at the keyboard (often
in poor light anyway).
How can I disable it?

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



widman wrote:

I now know how to turn it of in Word, but it is a real pain in Excel when it
keeps popping up when I want the F2 key or escape key. I use too many
different keyboards and am not in the habit or looking at the keyboard (often
in poor light anyway).
How can I disable it?

--

Dave Peterson

I must be doing something wrong, but copied and pasted the first part into a
new module in my personal macro book, but the key is still alive and kicking.

"Dave Peterson" wrote:

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



widman wrote:

I now know how to turn it of in Word, but it is a real pain in Excel when it
keeps popping up when I want the F2 key or escape key. I use too many
different keyboards and am not in the habit or looking at the keyboard (often
in poor light anyway).
How can I disable it?

--

Dave Peterson

Did you run that macro?

Or add a line to the auto_open subroutine

sub auto_open()
'your code here
call disablef1
end sub

and corresponding:

sub auto_close()
'your code here
call enableF1
end sub

widman wrote:

I must be doing something wrong, but copied and pasted the first part into a
new module in my personal macro book, but the key is still alive and kicking.

"Dave Peterson" wrote:

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



widman wrote:

I now know how to turn it of in Word, but it is a real pain in Excel when it
keeps popping up when I want the F2 key or escape key. I use too many
different keyboards and am not in the habit or looking at the keyboard (often
in poor light anyway).
How can I disable it?

--

Dave Peterson


--

Dave Peterson

thanks, that is great
now let's teach microsoft

"Dave Peterson" wrote:

Did you run that macro?

Or add a line to the auto_open subroutine

sub auto_open()
'your code here
call disablef1
end sub

and corresponding:

sub auto_close()
'your code here
call enableF1
end sub

widman wrote:

I must be doing something wrong, but copied and pasted the first part into a
new module in my personal macro book, but the key is still alive and kicking.

"Dave Peterson" wrote:

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



widman wrote:

I now know how to turn it of in Word, but it is a real pain in Excel when it
keeps popping up when I want the F2 key or escape key. I use too many
different keyboards and am not in the habit or looking at the keyboard (often
in poor light anyway).
How can I disable it?

--

Dave Peterson


--

Dave Peterson