This macro is helpful for saving all open excel workbooks. This macro is helpful if you have several excel workbooks open and want to save them all at once. It is best to run this macro before running other macros or performing tasks that could potentially freeze up your excel to prevent losing your work.
Assign this macro to a shortcut key to gain the full time-saving benefit.
Excel Macro Code:
Sub SaveAll() Application.ScreenUpdating = False Dim Wkb As Workbook For Each Wkb In Workbooks If Not Wkb.ReadOnly And Windows(Wkb.Name).Visible Then Wkb.Save End If Next Application.ScreenUpdating = True End Sub
View the full listing of macros.