Macro: Save All

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.

Once you add this macro all you will need to do is run the macro (the macro will be named SaveAll).

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s