Disabling F1 and F12 while editing a cell

[ndell]

I'm trying to disable the F1 and F12 keys.

In my workbook open event, I put:

Application.OnKey "{F1}", ""
Application.OnKey "{F12}", ""

This does the trick until I double-click a cell to edit
directly in the cell. Then F1 and F12 become functional again.

Any suggestions on disabling those keys whilst directly editing a cell?

Thanks.

 

[ndell]

help?

 

[Jaafar Tribak]

I never noticed this peculiarity !

A while back, I worked on a hack to detect and capture keyboard presses via the use of a system wide keyboard hook.

However, this would seem overkill as it's code hungry and has an impact on the machine performance.

See if you acn adapt the code here : http://www.mrexcel.com/board2/viewtopic.php?t=203781&highlight=setwindowshookex

and here: http://www.mrexcel.com/board2/viewtopic.php?t=188477&highlight=setwindowshookex

Regards.