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.

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.

Just another thought:

I think the OP wants to disable the menu whenever the user is editing the
cell - F2 is just one method of going into edit mode and probably the least
likely to be used. Many people refer to editing a cell as F2. If my
interpretation is correct, then OnKey won't be sufficient.

--
Regards,
Tom Ogilvy


"Jim Thomlinson" wrote in message
...
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.

I thought the request was a little odd also. He asked about detecting F2 so I
gave him what he asked for. I showed him how to pull the trigger. I did not
worry too much about where he was pointing the gun. My assumption was the it
would be a learning experience. As always though... Good point!
--
HTH...

Jim Thomlinson


"Tom Ogilvy" wrote:

Just another thought:

I think the OP wants to disable the menu whenever the user is editing the
cell - F2 is just one method of going into edit mode and probably the least
likely to be used. Many people refer to editing a cell as F2. If my
interpretation is correct, then OnKey won't be sufficient.

--
Regards,
Tom Ogilvy


"Jim Thomlinson" wrote in message
...
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.

Thanks for the information. I am newbee in Office Programming.
(I am writing windows programs in C++)
Back to my problem. All I need is to detect the situation when
the user editing the cell and then enable/disable my menu item
just as Excel enable/disables some menu items e.g. Open.
I don't want to change the functionality of F2 key.

Regards
ji


"Jim Thomlinson" wrote:

I thought the request was a little odd also. He asked about detecting F2 so I
gave him what he asked for. I showed him how to pull the trigger. I did not
worry too much about where he was pointing the gun. My assumption was the it
would be a learning experience. As always though... Good point!
--
HTH...

Jim Thomlinson


"Tom Ogilvy" wrote:

Just another thought:

I think the OP wants to disable the menu whenever the user is editing the
cell - F2 is just one method of going into edit mode and probably the least
likely to be used. Many people refer to editing a cell as F2. If my
interpretation is correct, then OnKey won't be sufficient.

--
Regards,
Tom Ogilvy


"Jim Thomlinson" wrote in message
...
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.