VBA does not deal in formulas. I think you need a macro.
Sub closer()
Application.DisplayAlerts = False
With ActiveWorkbook
.Save
.Close
End With
Application.DisplayAlerts = True
End Sub
Gord
On Tue, 24 Jan 2012 12:43:13 -0800 (PST), dave
wrote:
Hello,
I need a VB formula to exit workbook. When pressed to close button on
the form, I want the whole workbook saved and closed. Please help
Thanks
Dave