View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_4_] Jim Thomlinson[_4_] is offline
external usenet poster
 
Posts: 1,119
Default How to detect "F2 key" event

Look up Application.Onkey in the help menu. I think this will give you what
you need. Keep in mind that this is an application level setting so it exists
for the entire application, not just a specific book. And as always with
application level settings use an error handler to ensure that proper clean
up is done if something goes wrong.
--
HTH...

Jim Thomlinson


"ji" wrote:

I have create my own menu item. I want to disable it (I know how)
when the user editing cell (he pressed F2 key)
but I can“t find out how to detect this event.