save changes on close using vba
 

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?

--
Carlee

save changes on close using vba
 

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

"Carlee" wrote:

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?

--
Carlee