First of all, I look to this site ALOT and find tons of useful
information here. Thanks!

Here's my problem:

User base has Office 2002 and just received an XP Service Pack 2
install. Suddenly, when using Excel, they are experiencing a generic
'Microsoft Excel has encountered a problem and needs to close...'.
There have been no other recent updates to the spreadsheets.

The spreadsheets they are using all get this error when they click on
an ActiveX button that runs code. The code gathers data from the
spreadsheet and creates a set of xml that then gets sent to a service
on our server.

We found a work around (a real icky one). When we go into the VBE and
select Tools... References... Then 'uncheck' any one of the
references. Click OK. Then, go right back into Tools... References...
and 'check' the same reference. Click OK. Once this has been done,
the spreadsheet works fine. However, this has to be done to EACH
spreadsheet. NOT GOOD. Also, this is not something we want the users
to have to do.

Any idea what caused this to begin with?

Any idea what actually happens when you go through the Tools...
References... dialog? It seems like 'something' get 'recalibrated' in
some way. If we can find out what is happening, maybe that would lead
us to a way to fix this.

HELP!!!