MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Disable F1

Posted by Avi on July 11, 2001 6:27 AM

I always hit the F1 key when trying to edit a cell (F2). This is bugging me as it pulls up help which just wastes time. Please reply if you know how to diable F1 key.

Posted by Ivan F Moala on July 11, 2001 12:44 PM

Sub DisableF1()
Application.OnKey "{F1}", ""
End Sub

Sub EnableF1()
Application.OnKey "{F1}"
End Sub