Disable F1 key?

[Guest]

I'd like to disable the F1 key because I frequently hit it inadvertently when trying to hit F2. Any ideas?

 

[Lady Layla]

pop it off with a screwdriver


: I'd like to disable the F1 key because I frequently hit it inadvertently when
trying to hit F2. Any ideas?

 

[Dave Peterson]

Maybe you could a line or two to your personal.xls (auto_open/workbook_open
procedure):

Option Explicit
Sub disableF1()
Application.OnKey "{f1}", ""
End Sub
Sub enableF1()
Application.OnKey "{f1}"
End Sub

If you pop the F1 key off, you may want to remove the spring and put the keytop
back. It'll look prettier!