"Do you want to save" when Excel OPENS

[Stan Brown]

I understand about the "Do you want to save" message when you close
Excel, even if you didn't make any changes: Excel doesn't distinguish
between real changes and the recalculation of volatile functions.

But at work we've had a user claim that he gets the message when he
OPENS Excel when our add-in is checked (having been checked when
Excel was open before). Specifically, it asks "Do you want to save
changes to Sheet 2?" I'm sure it's not our add-in as such, since no
one has ever report this before. But it may be some interaction
between our add-in and something unusual on the user's machine or
Excel settings.

Does anyone have any idea where I should start looking? I've already
queried about VBA start-up code and anything in the Excel startup
folder(s).

 

[LEO@KCC]

Stan,

I would start by looking in the XLA project for Open event statements. They
could be under ThisWorkbook_Open() or Auto_Open(). Look for the error
message string that you received, as it doesn't look like a MS Excel error
message, more like a msgbox man-made message. Another, unlikely, option
could be that there is something written in the Class Module of the Personal
Workbook.xls used for application-level events that triggers when a workbook
is opened and the Add-in is installed.

If you are certain that the same behaviour does not happen in other
machines, it sounds like it has to do with the user's Personal Workbook...
You can try, providing that this is acceptable, deleting the user's Personal
workbook file and then recording a random macro, to force the creation of a
new one, and then testing again in the users machine.

To be honest there could be a number of different things, but at least this
is a start.

Leo