ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   disable F1 after F2 (https://www.excelbanter.com/excel-programming/321975-disable-f1-after-f2.html)

Dw70

disable F1 after F2
 
How can I disable F1 key in edit mode (after F2)
when I write:
Private Sub Workbook_Open()
Application.OnKey "{F1}", ""
End Sub
it helps only if celing is not editing



Tom Ogilvy

disable F1 after F2
 
No. You don't have any control over editing that I am aware of. If you do,
it is minimal and does not include redefining keys.

--
Regards,
Tom Ogilvy

"Dw70" wrote in message
...
How can I disable F1 key in edit mode (after F2)
when I write:
Private Sub Workbook_Open()
Application.OnKey "{F1}", ""
End Sub
it helps only if celing is not editing






All times are GMT +1. The time now is 10:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com