.Net Add-in needs to catch cell edits prior to committing

[Guest]

I have a .net addin which adds it's own command bar. I
want to catch when a cell is mid-edit and prevent my
menus from running until the edit is commited or
cancelled.

But I can't see a way to do this from the excel object
model.

Is this possible?

 

[Allan]

To catch if the user is mid-edit - I'm setting

application.interactive=false

and catching if there is com interop error; but surely
theres a better way to verify cell editing.

 

[Jens Thiel]

There are better ways in native code (or using P/Invoke, but YMMV).

Best regards,

Jens.