| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
close excel
is it possible for excel to close when then last workwook is closed. I would
like to do this with a macro in sub autoclose. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
close excel
Hi
not tested but try sub workbook_beforeclose() if workbooks.count=1 then application.quit end if end sub "Sunil" wrote: is it possible for excel to close when then last workwook is closed. I would like to do this with a macro in sub autoclose. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why excel close all files when I just want to close one files | Excel Discussion (Misc queries) | |||
| why do all excel worksheets/workbooks close when I close one? | Excel Discussion (Misc queries) | |||
| Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
| excel - Windows close button (x) should only close active workboo. | Setting up and Configuration of Excel | |||
| Close excel | Excel Programming | |||
Linear Mode
