I have written a C# Automation Add-In for Excel. Everything is working as
desired with one exception. I have a doubleclick handler that brings up a
form to edit the formula in that cell. However, when the form is closed
(either because the user made a change and clicked OK, or clicked Cancel)
Excel always enters edit-mode on that cell. I have to programatically then
select the neighboring cell and then reselect the current cell so that it
appears to the user to not have entered edit mode. It was my understanding
that the "ref bool bCancel" param on the doubleclick handler was to address
this issue but whether I set bCancel to true or false, I cannot avoid this
problem. Help?
thanks!