Tags Tags

Need VB formula to exit workbook

January 24th, 2012 - 03:43 pm ET by dave | Report spam
Help Create a new topic
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
email Follow the discussionReplies 1 replyReplies Make a reply

Similar topics

Replies

#1 Gord Dibben
January 24th, 2012 - 08:19 pm ET | Report spam
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
email Follow the discussion Replies Reply to this message
Help Create a new topicReplies Make a reply
Search Make your own search