View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff Wright[_2_] Jeff Wright[_2_] is offline
external usenet poster
 
Posts: 47
Default Close workbook without alerts

Hi,

I don't want users of my workbook to have the option of saving changes when
closing. I tried:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Application.DisplayAlerts = False
End Sub

.. . . but this doesn't work. How can I code my workbook to close with no
prompts to the user??

Thanks!!

Jeff