Can I disable F1 starting the Help screens?
I would put it in "this workbook" of the Personal workbook, since it sounds
like you want to use it for all your Excel work.
I found the place to save the Personal workbook by running the following
macro:
Public Sub ShowPaths()
MsgBox Application.StartupPath
End Sub
"Ken Johnson" wrote:
Hi Jen,
Private Sub Workbook_Open()
Application.OnKey "{F1}", ""
End Sub
pasted into your workbook's ThisWorkbook code module will disable the
F1 key.
Ken Johnson
|