Any way to disable F1? or other F Keys.

TIA,

David Steed

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

David Steed wrote:
>
> Any way to disable F1? or other F Keys.
>
> TIA,
>
> David Steed

--

Dave Peterson

Hi Dave

This is one of the keys that if you are in Edit mode it is still working .

I vote for this
> Chip Pearson says that he actually "fixed" his keyboard by taking that key off.

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Dave Peterson" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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
>
> David Steed wrote:
>>
>> Any way to disable F1? or other F Keys.
>>
>> TIA,
>>
>> David Steed
>
> --
>
> Dave Peterson