Need help writing an excel macro

Question

When I go to close out a spreadsheet the dialog box pops up that asks if you want to save. Is there code that I can add in the macro to respond to the dialog box?

Answer 1

Yes there is:

In a module (in the VB editor, Insert, Module), add the following macro:

Sub Auto_Close()

  ActiveWorkbook.Save

End Sub

This will save the workbook when you close it and *not* bring up that dialog box.

Hope that helps