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?