Closing workbooks w/o closing Excel

[Barb in MD]

Other than shift, file, close all, is there a way to close all open workbooks
w/o closing Exel?

 

[trip_to_tokyo]

Barb, I think this question has been asked before and I think that the
conclusion at the time was no.

 

[APK]

I have a cell lets say it is I33 and it total <10, I want Cell K33 to the =
5, next if Cell I33 = 10:15 the Cell K33 = 10. HOw do I get this to work.

 

[Barb in MD]

Thanks for the info. I didn't see where it'd been asked before. Sorry for
the duplicate.

 

[מיכ×ל (מיקי) ×בידן]

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