Custom Menu Focus
 

I have created a custom menu that work fine except ...
when double clicking on a cell to get focus to type in that cell. Then
the custom menu will not open.
I notice most of the other menus (font, print, file, etc) work fine when
this happens.
The reason I made the menu was to open a form that has prepared statements
to input into the selected cell. It is frustrating to stop typing in the 1st
cell- click on another cell - then click on the 1st cell again to input the
statement.

Where did I go wrong?

Hank

Custom Menu Focus
 

Hi Hank

Unfortunately, VBA code won't be run when focus is in the formula bar.
However, COM Addins do execute when focus is in the formula bar. I suggest
you convert your form to a COM Addin, using either the Office 2000/2002
Developer Edition, VB6 or .NET
--
Regards

Stephen Bullen
Take your Excel development to the highest levels
with "Professional Excel Development",
www.oaltd.co.uk/ProExcelDev


"Hank" wrote:

I have created a custom menu that work fine except ...
when double clicking on a cell to get focus to type in that cell. Then
the custom menu will not open.
I notice most of the other menus (font, print, file, etc) work fine when
this happens.
The reason I made the menu was to open a form that has prepared statements
to input into the selected cell. It is frustrating to stop typing in the 1st
cell- click on another cell - then click on the 1st cell again to input the
statement.

Where did I go wrong?

Hank