Thread: Disable Alert
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] YoureNotAtHomeNow@googlemail.com is offline
external usenet poster
 
Posts: 17
Default Disable Alert

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