Disable F1 help key

[widman]

Is there anyway to disable the F1 key? If for some reason some day I need
help, it is on the menu. I use too many different keyboards, and use the F2
key 100 times a day. but depending on the keyboard, there is a different
distance from the edge of the keyboard to the F2.
It is ridiculos to have nothing happening with your keystrokes while the
screen resizes and the help screen opens. After 15 years of using Excel, I
think I can do without the help screen.

 

[Mike Hall \(MS-MVP\)]

After 15 years on a keyboard, you should be have learned to miss the F1
key..

 

[Timothy L]

I can't figure out how to do this in Microsoft Excel, but here are the instructions for Microsoft Word if
anyone is looking for it.



In Microsoft Word, go to Tools -> Customize... in the menu bar.

Click on Options (tab) and then click on the Keyboard... button at the bottom.

At the top of this dialog, find where it says "Specify a command" and then under "Categories:", select "Window
and Help" from the list. To the right of it under "Commands:", select "Help" from the list.

Just below that where it says "Specify keyboard sequence", you will find "Current keys:". Select "F1" from
that very short list (as F1 should be the only one there).

At the bottom of that same dialog box (AFTER selecting "F1"), click the "Remove" button.

Click the "Close" button and then click the other "Close" button.

 

[Milly Staples [MVP - Outlook]]

You are exceedingly naughty for a Sunday!

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, Mike Hall (MS-MVP) asked:

| After 15 years on a keyboard, you should be have learned to miss the
| F1 key..
|
|
| || Is there anyway to disable the F1 key? If for some reason some day
|| I need help, it is on the menu. I use too many different keyboards,
|| and use the F2
|| key 100 times a day. but depending on the keyboard, there is a
|| different distance from the edge of the keyboard to the F2.
|| It is ridiculos to have nothing happening with your keystrokes while
|| the screen resizes and the help screen opens. After 15 years of
|| using Excel, I
|| think I can do without the help screen.

 

[widman]

Great for Word, But the bigget problem is Excel that I use all day.

In those 15 years I've used 30 or more keyboards. Right now I have a 12
inch toshiba, a 14 inch toshiba, a 15 inch toshiba and a 17 inch Dell. The
last two toshibas have the same keyboard, but diferent spacing from the edge
(on the latest, they put the power button where the escape key is on the
others). The Dell has a totally different keyboard and different spacing.
-Not to mention 6 desktops with two different keyboards between them.
I think anyone who can't find the HELP menu across the top will never find
the F1 key intentionally.

 

[JoAnn Paules [MSFT MVP]]

I've never noticed that the day of the week affected his responses.

--

JoAnn Paules
MVP Microsoft [Publisher]



"Milly Staples [MVP - Outlook]"

 

[Mike Hall \(MS-MVP\)]

ROTFL.. Sunday, I use a Smiley face.. other days of the week, I might use a
smiley face..


--
Mike Hall
MVP - Windows Shell/User

I've never noticed that the day of the week affected his responses.

--

JoAnn Paules
MVP Microsoft [Publisher]



"Milly Staples [MVP - Outlook]"

You are exceedingly naughty for a Sunday!

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, Mike Hall (MS-MVP) asked:

| After 15 years on a keyboard, you should be have learned to miss the
| F1 key..
|
|
| || Is there anyway to disable the F1 key? If for some reason some day
|| I need help, it is on the menu. I use too many different keyboards,
|| and use the F2
|| key 100 times a day. but depending on the keyboard, there is a
|| different distance from the edge of the keyboard to the F2.
|| It is ridiculos to have nothing happening with your keystrokes while
|| the screen resizes and the help screen opens. After 15 years of
|| using Excel, I
|| think I can do without the help screen.

 

[JoAnn Paules [MSFT MVP]]

Awwwww! Now you know that Smiley is a protect copyright or trademark or
whatever. I'm gonna tell!

--

JoAnn Paules
MVP Microsoft [Publisher]

ROTFL.. Sunday, I use a Smiley face.. other days of the week, I might use
a smiley face..


--
Mike Hall
MVP - Windows Shell/User

I've never noticed that the day of the week affected his responses.

--

JoAnn Paules
MVP Microsoft [Publisher]



"Milly Staples [MVP - Outlook]"

You are exceedingly naughty for a Sunday!

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, Mike Hall (MS-MVP) asked:

| After 15 years on a keyboard, you should be have learned to miss the
| F1 key..
|
|
| || Is there anyway to disable the F1 key? If for some reason some day
|| I need help, it is on the menu. I use too many different keyboards,
|| and use the F2
|| key 100 times a day. but depending on the keyboard, there is a
|| different distance from the edge of the keyboard to the F2.
|| It is ridiculos to have nothing happening with your keystrokes while
|| the screen resizes and the help screen opens. After 15 years of
|| using Excel, I
|| think I can do without the help screen.

 

[Harlan Grove]

Great for Word, But the bigget problem is Excel that I use all day.

....

Better to ask Excel questions in Excel newsgroups. But it's not that
difficult to do in Excel.

If you want this all the time, best to put it in the Workbook_Open event
handler in your Personal.xls file.

Application.OnKey "{F1}", "DoNothing"

and add a general VBA module with the macro

Sub DoNothing()
End Sub