Close Excel Completely Using VBA

C

Celtic_Avenger

E Oveson


I sorted this.............

What I needed to do is place the

Application.Quit

part into the Workbook_Deactivate() VBA page, and not within the butto
VBA that had the save and close part.


So when the button was clicked it Saved........Closed th
Workbook......
Then closed the Application using the Deactivate code.


Thanks for all your help.


Celtic_Avenger
:) :) :) :) :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Close Excel Completely Using VBA 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
excel 2003(SP3) - Save problem with multiple workbooks and eventworkbook_deactivate 0
Close Excel Completely Using VBA 1
Need Help with Macro Security 1
Excel 2007 command buttons moving 1
Close Excel Completely Using VBA 1
Runtime Error 1004 1

Top