Painting Blue Code
Simple, self-explanatory code snippets.
2012-11-13
EXCEL - Save all open workbooks macro
This macro will save all open non-read-only workbooks.
Sub x()
Dim w As Workbook
For Each w In Workbooks
If Not w.ReadOnly Then
w.Save
End If
Next
End Sub
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment