Saving Workbooks

  • Thread starter Thread starter Jamad
  • Start date Start date
J

Jamad

Hi,
I want to save all my opened workbooks once without having to be saving and
closing each workbook individually. Thanks
 
Try this, hold down Shift key, then File, Close all. You will still have
to click Yes to save changes.
 
While holding down a shift key, click FILE in the menu and select CLOSE ALL..
If you've made any changes to a workbook a dialog box appears asking if you
want to save the changes made to "Workbookname". Click the YES TO ALL
command button and all modified workbooks will be saved and closed
automatically.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Multiple workbook sheets into one workbook 0
Opening on a specific worksheet 2
Excel Protection 2
How to create absolue path link to another workbook (Excel 2003) 1
Disable Macro Alert 2
Macro to push data to another workbook 0
personal.xls 3
Sharing workbooks limitations - Merged Cells 12

Back
Top