It's okay for an add-in to modify itself but it should never prompt to save
changes. The fact that it does suggests to me that it is not really an
add-in. Is it possible the "IsAddin" property have been changed to False?
You might try uninstalling the Analysis Toolpak and then reinstalling it;
the idea being to get the current XLA deleted and a new original installed.
If you try this make sure the Analysis folder under Office\Library is empty
after the uninstall.

--
Jim Rech
Excel MVP
"JD" wrote in message
...
| Greetings,
| I'm doing some development on an Excel 2002 workbook.
| the purpose of the workbook is to analyze some data and
| create graphs. I am using the Analysis toolpak addins
| for both Excel and VBA.
| The code runs correctly and I have no problems there. I
| can close the workbook without closing the application
| with no trouble, but when I close the application, I get
| the following message: "Do you want to save changes to
| Procdb.xla". I have no clue where to start on
| determining why this .xla file has been modified. I
| cannot see this module when I go to the VB editor.
|
| Anyone have any experience with this situation?
|
| thanks
|
|
| p.s. I've posted this question in the Office developer
| forum as well, but hey, I'm just looking for some help.
| thx