| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need VB formula to exit workbook
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need VB formula to exit workbook
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to set auto protect workbook on exit? | Excel Worksheet Functions | |||
| Exit Workbook | Excel Programming | |||
| [Fwd: Run macro on exit worksheet/workbook] | Excel Discussion (Misc queries) | |||
| Run macro on exit worksheet/workbook | Excel Worksheet Functions | |||
| Force no save on workbook exit | Excel Programming | |||
Linear Mode
