Is there a way to turn off the F1 key (help menu/task "pain") in Excel?

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

ih1234 wrote:

Is there a way to turn off the F1 key (help menu/task "pain") in Excel?

--

Dave Peterson

Hi Dave'

sorry to interrupt,
i do have same kind of matter,

While using excel, can i directly go to this forum by just hitting *F1* key ?
Is it possible by macro.. ?

regards,
driller

--
*****
birds of the same feather flock together..



"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

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

ih1234 wrote:

Is there a way to turn off the F1 key (help menu/task "pain") in Excel?

--

Dave Peterson

You're using Microsoft's CDO web interface. Maybe you could assign F1 to follow
a hyperlink to that site.

Option Explicit
Sub Reassign()
Application.OnKey "{f1}", "'" & ThisWorkbook.Name & "'!NewsGroup"
End Sub
Sub newsgroup()
ActiveWorkbook.FollowHyperlink "http://www.microsoft.com"
End Sub

You'll have to use the address to that page, though.

=======
But if you can use something else besides the CDO interface, it makes life
easier (although not all companies will allow you to connect to newsgroups
directly).

Saved from a previous post:

If you have Outlook Express installed, try clicking on these links (or copy and
paste into MSIE).

news://msnews.microsoft.com/microsof...ic.excel.setup
news://msnews.microsoft.com/microsoft.public.excel.misc
news://msnews.microsoft.com/microsof...heet.functions
news://msnews.microsoft.com/microsof...excel.newusers
news://msnews.microsoft.com/microsof...el.programming

(and a few more for MSWord)
news://msnews.microsoft.com/microsof....docmanagement
news://msnews.microsoft.com/microsof...word.word97vba
news://msnews.microsoft.com/microsof....word.newusers
news://msnews.microsoft.com/microsof...ord.pagelayout
news://msnews.microsoft.com/microsof...ord.vba.addins
news://msnews.microsoft.com/microsof....vba.beginners
news://msnews.microsoft.com/microsof....customization
news://msnews.microsoft.com/microsof...rd.vba.general
news://msnews.microsoft.com/microsof....vba.userforms
news://msnews.microsoft.com/microsof....word6-7macros

(You can always connect to more later)

Here are some links that explain it better:

Chip Pearson has some notes written by Leonard Meads at:
http://www.cpearson.com/excel/DirectConnect.htm

David McRitchie's notes at:
http://www.mvps.org/dmcritchie/excel/xlnews.htm
http://www.mvps.org/dmcritchie/excel/oe6.htm
http://www.mvps.org/dmcritchie/excel/oe6nws01.htm

Tushar Mehta's notes at:
http://www.tushar-mehta.com/misc_tut...e_ng/index.htm

And if you're looking for old posts:

Or you can use google (maybe a few hours behind) to search for stuff you've
posted (and find the replies, too)

http://groups.google.com/advanced_group_search
http://groups.google.com/advanced_gr...Excel*&num=100

Ron de Bruin has an excel addin that you may like:
http://www.rondebruin.nl/Google.htm

driller wrote:

Hi Dave'

sorry to interrupt,
i do have same kind of matter,

While using excel, can i directly go to this forum by just hitting *F1* key ?
Is it possible by macro.. ?

regards,
driller

--
*****
birds of the same feather flock together..

"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

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

ih1234 wrote:

Is there a way to turn off the F1 key (help menu/task "pain") in Excel?

--

Dave Peterson


--

Dave Peterson

Thanks Dave, the Macro worked perfect. Seems there would be something built
into Excel to allow this to be toggled (like in Word)... but that would be
too simple now wouldn't it?

"ih1234" wrote:

Is there a way to turn off the F1 key (help menu/task "pain") in Excel?