| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing file and excel
great... just what I wanted
Thanks JP "Frank Kabel" schreef in bericht ... Hi try Private Sub CommandButton4_Click() activeworkbook.save application.quit end sub -- Regards Frank Kabel Frankfurt, Germany "Jean-Paul De Winter" schrieb im Newsbeitrag ... Hi, I created a pushbutton with following code: Private Sub CommandButton4_Click() ActiveWorkbook.Close End Sub When I click I am asked if I want to save the workbook.... Tha idea is, when clicking the button, ALWAYS save the wrokbook and close excel. What code should I add? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel closing down when I attempt to enter = in one file and then | Excel Discussion (Misc queries) | |||
| Opening then later Closing an Excel file in VBA | Excel Discussion (Misc queries) | |||
| Error with closing the Excel file | Excel Discussion (Misc queries) | |||
| Excel Crashes after Inserting New Worksheet and Closing the File | Excel Discussion (Misc queries) | |||
| Unexpected error message on closing an Excel file | Excel Discussion (Misc queries) | |||
Threaded Mode
