B
Barb in MD
Other than shift, file, close all, is there a way to close all open workbooks
w/o closing Exel?
w/o closing Exel?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
trip_to_tokyo
Barb, I think this question has been asked before and I think that the
conclusion at the time was no.
conclusion at the time was no.
A
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.
5, next if Cell I33 = 10:15 the Cell K33 = 10. HOw do I get this to work.
B
Barb in MD
Thanks for the info. I didn't see where it'd been asked before. Sorry for
the duplicate.
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
------------------------------------------------
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