Prev: Series button
Next: formula to calculate month-month
From: Barb in MD on 15 Feb 2010 13:03
Other than shift, file, close all, is there a way to close all open workbooks
w/o closing Exel?
--
Barb
From: trip_to_tokyo on 15 Feb 2010 13:21
Barb, I think this question has been asked before and I think that the
conclusion at the time was no.

"Barb in MD" wrote:

> Other than shift, file, close all, is there a way to close all open workbooks
> w/o closing Exel?
> --
> Barb
From: Barb in MD on 15 Feb 2010 13:42
Thanks for the info. I didn't see where it'd been asked before. Sorry for
the duplicate.
--
Barb


"trip_to_tokyo" wrote:

> Barb, I think this question has been asked before and I think that the
> conclusion at the time was no.
>
> "Barb in MD" wrote:
>
> > Other than shift, file, close all, is there a way to close all open workbooks
> > w/o closing Exel?
> > --
> > Barb
From: מיכאל (מיקי) אבידן on 15 Feb 2010 13:44
If you don't mind using a tiny macro - check out this:
------------------------------------------------
Sub CloseAndSaveOpenWorkbooks()
Application.ScreenUpdating = False
For Each WB In Workbooks
If Not WB.ReadOnly Then WB.Save
If WB.Name <> ThisWorkbook.Name Then WB.Close
Next
ActiveWorkbook.Close
Application.ScreenUpdating = True
End Sub
-------------------
Micky


"Barb in MD" wrote:

> Other than shift, file, close all, is there a way to close all open workbooks
> w/o closing Exel?
> --
> Barb
 | 
Pages: 1
Prev: Series button
Next: formula to calculate month-month