PExcel AddIn hangs when trying to access data programatically

[rakhitha.karunarathne]

This problem is related to what is discussed in following post

http://groups.google.lk/group/micro...is+being+edited&rnum=2&hl=en#3f42fa51339b4677

What I developing is an excel add-in which transfer data between excel
and a business application. The problem is if user click transfer
button while he is editing the cell (Cursor is inside the cell) my
code try to read the data from spreadsheet and it hangs. (Execution
resume if the user ends editing)

So Is there any way I can detect if a cell being edited and then warn
the user or cancel editing programatically before executing the code
that make the program hang.

 

[NickHK]

Assuming this will not be running in the VBA environment, MS has advised
checking Application.Ready, but many report this does not work.
Alternative is to check if a suitable menu item is disabled e.g File>Open.

NickHK