Prevent save changes dialog box upon closing

Question

I have spreadsheet which uses events upon opening, therefore anytime I try to close the file, the save changes dialog box appears.

Is there a way to prevent this?

Answer 1

You can add a function in VBA to ThisWorkbook to let Excel think that the file has been saved. This will prevent any save prompts.

If you don't want to save your workbook:

Private Sub Workbook_BeforeClose(Cancel As Boolean)

    Me.Saved = True

End Sub

If you want to save your workbook:

Private Sub Workbook_BeforeClose(Cancel As Boolean)

    Me.Save

End Sub

Answer 2

Here documentation for deleting work sheet.

So, you need to use as follow:

'Stopping Application Alerts
Application.DisplayAlerts=FALSE

'~~~~~~deleting sheet~~~~~

'Enabling Application alerts once we are done with our task
Application.DisplayAlerts=TRUE

Answer 3

Private Sub Workbook_BeforeClose(Cancel As Boolean)
 ThisWorkbook.Close SaveChanges:=False
End Sub