View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Michael[_20_] Michael[_20_] is offline
external usenet poster
 
Posts: 15
Default DisplayAlerts property is not changing to False

Mike,

You may want to try using the saved property of the
Workbook Object. For example:

ThisWorkbook.Saved = True
Application.Quit

If you have more than one workbook open and you want all
of them closed without saving any of them, try:

Dim wkBooks
Dim wkBook

Set wkBooks = Application.Workbooks

For Each wkBook In wkBooks
wkBook.Saved = True
wkBook.Close
Next wkBook
Application.Quit

Hopefully that helps.

Michael