Save All??

  • Thread starter Thread starter Mike the Kiwi
  • Start date Start date
M

Mike the Kiwi

Hi, I am using Office 2002, and I with Excel I often have several pages open at once. Does this version of Excel (or later
versions) have a Save All feature??

All assistance is greatly appreciated,
Cheers
Mike the Kiwi
 
Not if you mean multiple workbooks, if multiple sheets in the same workbook
yes.
For multiple workbooks you would need VBA

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
pages = Workbooks????

If you want to close all of the open workbooks and save while closing them:

Hold the shift key and click File.
You'll see Close All
You can answer "yes to all" when prompted with the "do you want to save changes
to bookx.xls?"
(You can get the same prompt by closing excel, too.)

If you mean SaveAll and you want to stay in all the workbooks, then this isn't
build into xl2002.

you'd have to use a macro:

Option Explicit
Sub mySaveAll()
Dim wkbk As Workbook

For Each wkbk In Workbooks
If wkbk.Path = "" Then
MsgBox "please save " & wkbk.Name & " manually first"
Else
wkbk.Save
End If
Next wkbk
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

===
And you didn't ask, but if you want to close without saving anything, you can
close excel and when prompted, shift-click the "no" (do you want to save
bookx.xls).
 
Back
Top