Disable Alert
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
|