Excel: mis-hitting F1 key for F2 key aggravation
Excel: mis-hitting F1 key for F2 key aggravation
(OP)
An Excel tip: I use the F2 keyboard key all the time to activate cells for editing. For years I had been bothered by accidentally hitting the F1 key, this causes a long pause while waiting for the Help system to open instead.
In another forum I read about a guy so desperate that he removed the F1 function key cap (it's not fun when this happens a dozen or more times a day!). I took his advice and for the past couple years I have lived without the F1 key cap. I do need the F1 key on occasion (for Excel or other software) but it's a simple matter to stick a pen down in the key well to activate the F1 key.
In another forum I read about a guy so desperate that he removed the F1 function key cap (it's not fun when this happens a dozen or more times a day!). I took his advice and for the past couple years I have lived without the F1 key cap. I do need the F1 key on occasion (for Excel or other software) but it's a simple matter to stick a pen down in the key well to activate the F1 key.





RE: Excel: mis-hitting F1 key for F2 key aggravation
Best regards
Morten
RE: Excel: mis-hitting F1 key for F2 key aggravation
Would it be safer to remove all the keycaps and just stick a pen down the holes when I need to type?
(I assume that you intend this thread as a joke)
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
Steam Engine enthusiasts
Steam Engine Prints
RE: Excel: mis-hitting F1 key for F2 key aggravation
http://www.pcmag.com/article2/0,4149,19645,00.asp
I have not tried it but it seems as if you can disable keys (electronically instead of a piece of duck tape over the hole where the key was after you removed it)
Stephen Argles
Land & Marine
www.landandmarine.com
RE: Excel: mis-hitting F1 key for F2 key aggravation
CODE
Application.OnKey "{F1}", ""
End Sub
RE: Excel: mis-hitting F1 key for F2 key aggravation
F1 = F2 when you are in excel then either
would give you the result?
.
RE: Excel: mis-hitting F1 key for F2 key aggravation
The "OnKey" command lends itself nicely to this problem. I can turn off the F1 key action. But my disabled left claw will probably still hit the F1 key more often than not when attempting to press F2. I'm sure there is a way to swap the behavior of the F1 and F2 keys.
But...I have a problem with the "OnKey" command. Since that is a new issue, I will begin new thread.
RE: Excel: mis-hitting F1 key for F2 key aggravation
Seems far less invasive than any of the other options.
RE: Excel: mis-hitting F1 key for F2 key aggravation
With April 1st coming up I think I can configure all the keyboards in my office to act erratically.
Everyone here is using a customized add-in which I can add code to. I think I'll give myself a pat on the back every time someone uses the "a" key.
CODE
Application.OnKey "a", "Pat_on_the_back"
End Sub
Sub Pat_on_the_back()
MsgBox "Brad is a genius."
ActiveCell.Value = ActiveCell.Value + "a"
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.OnKey "a", ""
End Sub
Incidentally while I was testing this I first used SendKeys to add the "a" where it was typed and not surprisingly I got caught in an endless loop. I sprained my arm patting myself on the back so often.
Boy, I kill me.
Brad
RE: Excel: mis-hitting F1 key for F2 key aggravation
Along with Brad's contribution, you may find the following SUBs to be of interest ...
CODE
'Mar-10-2007 ... macro by Yogi Anand
'call switchF1F2 to switch F1 key to F2 functionality
Application.OnKey "{F1}", "switchF1F2"
End Sub
Sub switchF1F2()
'Mar-10-2007 ... macro by Yogi Anand
'switches F1 key to F2 functionality
Application.SendKeys "{F2}", True
End Sub
Sub RestoreF1()
'Mar-10-2007 ... macro by Yogi Anand
'restores F1 key functionality
Application.OnKey "{F1}"
End Sub
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
ANAND Enterprises LLC
http://www.energyefficientbuild.com