Determine if Cell has cursor

[Khai]

I'm using VB6 sp5, and binding to Excel 10, to an open workbook.

What I'm having issues resolving is :

If Excel has a cell which is being "edited" (has the cursor inside it,
blinking, waiting for input), then my app cannot control Excel. It's as if
Excel has a "if being edited, then lockdown binding controls" somewhere.

Has anyone experienced this problem or have a suggested work around?

-thanks,
Khai

 

[jaf]

Sorry.
Everyone has experienced it and there is no solution but to live with it.
All events and code are suspended when editing or entering data in a cell.


--
John
johnf 202 at hotmail dot com


| I'm using VB6 sp5, and binding to Excel 10, to an open workbook.
|
| What I'm having issues resolving is :
|
| If Excel has a cell which is being "edited" (has the cursor inside it,
| blinking, waiting for input), then my app cannot control Excel. It's as
if
| Excel has a "if being edited, then lockdown binding controls" somewhere.
|
| Has anyone experienced this problem or have a suggested work around?
|
| -thanks,
| Khai
|
|