Workbook Before_Close question

[Stuart]

If user clicks the little 'x' in top right corner, then
I believe I can trap this with the Before_Close Event.
prior to the book closing.

Providing code has not saved the activeworbook
prior to this point, how do I Close without Saving
changes, please?

Regards.

 

[Ron de Bruin]

Try this Stuart

how do I Close without Saving changes, please?

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

 

[Stuart]

Got it.
Many thanks.

Regards

Try this Stuart


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