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.