OWC crashes in event procedure

[Iain]

I'm using the spreadsheet component in VB6, and keep having my
application crash on me at the end of one specific event routine. What
happens is this:


1. I start the application and enter data in a cell in the
spreadsheet.
2. There are two objects trapping events for the spreadsheet. The
SheetChange event fires, correctly, in first one then the other. I do
some checking of the input value at this point, and raise a public
event for other applications.
3. Now the strange part. If I am running the application in the
development environment, another event, "CommandBeforeExecute", fires,
and the command is ssCommmandMoveNext. This works fine, most of the
time, although sometimes it crashes. If however I am running the
compiled application, it always crashes right at the end of the second
SheetChange.

What is going on? Can anyone help?

Iain

 

[Alvin Bruney [MVP]]

post your code, or a short sample which demonstrates the problem