Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Close savechanges:=False
End Sub
亲 只需要在workbook 的BeforeClose 事件里面写上我上面这句ThisWorkbook.Close savechanges:=False就行哦 但是你所做的更更都不会保存哦,如果你想又保存且还不提示的话你要在之前就写一下保存的代码就象这样
thisworkbook.save
ThisWorkbook.Close savechanges:=False