.Net Automation Add-In - Execution Always Ends in Edit Mode

M

Matthew Wieder

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top