Application.Quit

[Excel-ent]

Dear experts,

I have a commandbutton, which if clicked quit excel.

Application.Quit

but you see if there was another workbook open at that time, and i had done some work on it, and didn't save it yet, excel doesn't quit application and it says; do you want to Save changes for the other document, if users press cancel, the application doesn't quit?

Thank you for your help.

 

[andshep]

What exactly do you want the button to do? Save the other work, and then exit? Exit without saving the work?

 

[Excel-ent]

with your wise question, i changed application.quit to Thisworkbook.close; it works fine...

Thank you...

 

[bandit_1981]

You can check and see how many workbooks are open first and if there is only one quit excel else close the workbook. So you get the best of both worlds