ExcelBanter - Disable Save Workbook popup

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Disable Save Workbook popup (https://www.excelbanter.com/excel-programming/337631-disable-save-workbook-popup.html)

Scott buckwalter

Disable Save Workbook popup

I have a workbook that I do not want the user prompted to save whenever they
close it. Is there a way I can disable that popup? Maybe override the
Workbook_OnClose event?

Scott buckwalter

Disable Save Workbook popup

Found it.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Me.Saved = True
End Sub

Works.

"Scott buckwalter" wrote:

I have a workbook that I do not want the user prompted to save whenever they
close it. Is there a way I can disable that popup? Maybe override the
Workbook_OnClose event?

All times are GMT +1. The time now is 05:09 AM.