| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatically close second workbook
i have put the following code in to workbook 'A' to close workbook 'B' but it
does not close book 'B' there is no error message Private Sub Workbook_BeforeClose(Cancel As Boolean) On Error Resume Next Workbooks("B.XLS").Close SaveChanges:=False ActiveWorkbook.Close SaveChanges:=True End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically close second workbook | Excel Discussion (Misc queries) | |||
| Close form automatically upon opening workbook | Excel Discussion (Misc queries) | |||
| Automatically Close Book1 | Excel Discussion (Misc queries) | |||
| Copy from another file and close automatically | Excel Discussion (Misc queries) | |||
| Close automatically a userform | Excel Discussion (Misc queries) | |||
Threaded Mode
