I have a custom command bar control which I want to disable whenever user clicks inside the formula bar.
You will notice that whenever user clicks inside the FormulaBar in excel, the File -- New menu is disabled. In the same way I want to disable my custom control when user clicks inside the formula bar. The problem I am facing is that there is no known event that triggers when excel is in edit mode. So I am not able to trap this scenario.
It would be great if anyone can provide some inputs into this.

Rajeev,

As far as I know what you want to do won't work.

However, once you are in edit mode with the cursor active in the formula
bar, you also cannot run a macro from a menu. In simple terms, VBA is
disabled the moment you start editing. The net effect is the same - that the
VBA routine is disabled even if the menu appears to be available.

I'm not sure from your question whether you are using something other than
VBA which is then called from the menu. If so, I don't know what the
behaviour would be I'm afraid, but I don't think there will be anything you
can do to disable the menu.

Robin Hammond
www.enhanceddatasystems.com

"Rajeev" wrote in message
...
I have a custom command bar control which I want to disable whenever user
clicks inside the formula bar.
You will notice that whenever user clicks inside the FormulaBar in excel,
the File -- New menu is disabled. In the same way I want to disable my
custom control when user clicks inside the formula bar. The problem I am
facing is that there is no known event that triggers when excel is in edit
mode. So I am not able to trap this scenario.
It would be great if anyone can provide some inputs into this.

Rajeev,

When you click in the formula bar, your custom control is disabled, by
virtue of the fact that the focus is on the worksheet, and VBE cannot take
the focus, and cannot run any macros. The only thing is that you cannot
explicitly see that it is disabled. Afraid I don't know how you could
intercept the formula edit, if indeed it is possible.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Rajeev" wrote in message
...
I have a custom command bar control which I want to disable whenever user
clicks inside the formula bar.
You will notice that whenever user clicks inside the FormulaBar in excel,
the File -- New menu is disabled. In the same way I want to disable my
custom control when user clicks inside the formula bar. The problem I am
facing is that there is no known event that triggers when excel is in edit
mode. So I am not able to trap this scenario.
It would be great if anyone can provide some inputs into this.