Problems with worksheet containing ActiveX controls

[Deane Yang]

I am running into lots of difficulties with a worksheet
that contains ActiveX controls. The situation is the following:
1) Worksheet contains, say, a combo box and corresponding
*_Change routine that modifies cells in ActiveSheet
2) Excel is in Automatic Calculation mode

When I try to save the spreadsheet, Excel seems to execute
some of the *_Change routines (why?) with the "wrong" ActiveSheet.
This, of course, creates an error condition.

I tried to put in error handling routines that would just
get out of the *_Change subroutines if an error occurred.
This eventually led to spreadsheets that crash Excel.

I also tried referring to the right worksheet using the Parent property
of the control. This also leads to error conditions that I do not understand.

Can anyone provide help or insight?

 

[Deane Yang]

Thanks for the advice. I basically want to write code for the controls
so that the worksheet can be copied and still work properly.

But I've noticed that when I copy the worksheet, funny things happen
to the original worksheet. And sometimes Excel just crashes.

And this is just due to ActiveX controls in a worksheet?