On May 6, 8:00*pm, Per Jessen wrote:
Hi

What are you trying to do ?

If you want to close the workbook without saving the workbook and no
alerts, then use the below in your "Workbook_BeforeClose" event (You
don't have to turn off the alert):

Thisworkbook.Saved=True.

Hopes this heps.

---
Per

On 6 Maj, 20:52, wrote:



I've put this in my 'This Workbook' space. *But it doesn't seem to be
working. *Any ideas?

Private Sub Workbook_BeforeClose(Cancel As Boolean)

'Disables 'Do you want to save changes?' Alert Before Close

* * Application.DisplayAlerts = False

End Sub- Hide quoted text -

- Show quoted text -

Thanks. It worked. Any ideas why my first try didn't work?