Closing Excel without promt to save (VBA?) 1

[excelhelp]

I'm trying to close Excel without having the prompt come up to save changes...the spreadsheet will be used as a template.

 

[CindyK]

Check out Microsoft Q213428. You could put following in workbook module:

Sub Auto_Close()
ThisWorkbook.Saved = True
End Sub

Hope this helps.

 

[excelhelp]

that did it, thanks!