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

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