Question:

Using Excel 97, I have several workbooks open.
My program takes control of excel, removing user access to all menus, shortcuts, etcs. The only means of closing the program that i leave them is the X on the top right corner.

We are experimenting to find a way to close all "my" open files.

Currently, we use DisplayAlerts= false, and Application.quit
with each file of my program saving automically with no user input required.

BUT *There's always a BUT.

a) if there are no open files from my program, close the application, using application.quit
b) if the user had files open prior, to close all my files, but to leave the user in Excel

Any suggestions on how to accomplish this?