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 |