save changes on close using vba

G

Guest

Hi All,

How can i programmatically save all changes made in a workbook, such that MS
Excel doesn't prompt the user before they close the workbook?
 
G

Guest

hi
in a thisworkbook module, paste this.
Private Sub Workbook_BeforeClose(Cancel As Boolean)
ActiveWorkbook.Save
End Sub
everytime someone closes the file excel will save it whether it needs saving
or not.

regards
FSt1
 

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

VBA editor doesn't prompt to save changes, doesn't save 3
deactivate save changes 1
Saying No to Message Box prompt through VBA 6
Macro to Close Workbook Without Save Any Changes Made 4
"Do you want to save changes?" question 5
Save Excel 2003 in Excel 2007 3
Need help on VBA excel macro and API to close an external application 0
Close w/o saving changes 6

Top