Search code examples
.netexcelvstocom-interop

How to tell if Excel Application is in cell-edit mode?

I'm writing an Excel Addin using COM Interop from .net. I have a command that pops up a dialog, and from the dialog I do some work like collecting data from the used range of several sheets. The problem is that if a cell is in edit mode, some of the calls that I need to make will throw exceptions. I would like a way of determining before-hand that Excel is in edit mode, so that I can warn the user to finish editing the cell first.

Any ideas?

Solution

  • There is an Application.Ready property that is supposed to give you this information but in practice it doesn't work reliably. See here for a hackaround.

    You might also want to look at setting Application.Interactive=false while your .net code is doing its stuff.