J
Jeff Wright
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
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