Public Sub submit()
' turn off prompts
Application.DisplayAlerts = False
ThisWorkbook.Close
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
'Save changes to workbook when closing, without prompting user.
Me.Save
' turn prompts back on
Application.DisplayAlerts = True
' place clear workbook code here
End Sub
Bookmarks