We have an Excel 97 spreadsheet that is attached to an ActiveX server. I am
now closing the server with an Auto_Close macro. But it runs this before
giving the user the message when the spreadsheet hasn't been saved, and if
the user chooses Cancel you are back in the workbook with the ActiveX
server no longer running. I tried putting the code in a BeforeClose, but
things seemed to work the same way.

The current situation isn't so bad. Before any calls to the server it
checks if still running, and if not it displays a MsgBox and the user
clicking ok starts it up again. Just I like to be as friendly as possible.

Don <donwiss at panix.com.