Need VB formula to exit workbook

D

dave

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need VB formula to retrieve data 19
Excel Providing user message when RED X clicked & properly closing application. 2
Saving & Removing VB Code from WB 6
Need VB formula to execute form 2
Access How Current page of a form Read Only 2
Excel Populate workbook A from Data in workbook B based off criteria in Workbook C 0
Excel sum if and closed workbooks 2
Copy system 4

Top