View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Patricia Shannon
 
Posts: n/a
Default 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