Exit Excel Macro

[SimonMag]

Hi,

I am trying to find a macro that will allow me to exit Excel and prompt to save the current workbook and then exit Excel. I want to also assign this to a button.

Thanks

Simon.

[jammer6_9]

Make a commandbutton and if symptomps persist ask the VBAX expert,

[vba]Private Sub CommandButton1_Click()
activeworkbook.close(Yes)
application.quit

End sub
[/vba]

[mdmackillop]

Hi Jammer
Our code posting is a little different from other sites. Select your code and click the VBA button to format it as shown.
Regards
MD

[jammer6_9]

Hi Jammer
Our code posting is a little different from other sites. Select your code and click the VBA button to format it as shown.
Regards
MD

[geekgirlau]

Hi Simon,

Just curious - isn't it quicker just to use the "X" in the top right corner of the Excel window? By default, if you have not saved any open workbook it will prompt you to save, then exit the application.