Excel 2007 vs 2010 disabling file save prompt -


we used following code in excel 2007 disable file save prompt:

private sub workbook_beforeclose(cancel boolean)     thisworkbook.saved = true end sub 

after upgrading excel 2010 code no longer works. have researched , tried of following code no luck:

private sub auto_close()     thisworkbook.saved = true end sub  application.displayalerts = false  private sub workbook_beforesave(byval saveasui boolean, cancel boolean)     cancel = true     application.displayalerts = false end sub    application.enableevents = false   application.displayalerts = false   if wasopened2 workbooks(filenamenopath(foundfiles(i))).close false    application.displayalerts = true   application.enableevents = true 

any other ideas appreciated.


Comments