I have three identical (bar the data) spreadsheets which get loaded at the
same time. They all contain an auto_close() macro.

If I close all three spreadsheets, one at a time, then the auto_close()
macro runs in each spreadsheet, so allowing me to clean up properly and
allowing me to avoid the "do you want to save" prompt. However, if I click
the close button for Excel, only one of the auto_close() macros runs. The
other two spreadsheets prompt the user to save the file.

I've put break points in the auto_close() macros for all three spreadsheets
and only one auto_close() is being run.

Anyone know whether this is by design or a bug and whether there is a
workaround for this behaviour?

Thanks
Steve