Workbook Before_Close question

Stuart · Jun 28, 2004

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 · Jun 28, 2004

Try this Stuart

how do I Close without Saving changes, please?

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

Stuart · Jun 28, 2004

Got it.
Many thanks.

Regards

Ron de Bruin said:
Try this Stuart

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