How to save all opened sheets at once?

[rowrow]

I have many workbook around 10 to 20 opened on my desktop.

I wish to click one time save and then it saves all the workbooks that are opened, instead of going to each workbook and click save which requires me to waste a lot of time.

How can I click once save to save all the opened workbook?

Thanks

[:) Sixthsense :)]

Whether by mistake you are calling the workbooks as sheets?

[sktneer]

The following links may be useful......

http://www.excelbanter.com/showthread.php?t=72022

http://www.accountingweb.com/topic/t...le-excel-files

[rowrow]

Whether by mistake you are calling the workbooks as sheets?

Yes My mistake. I mean workbooks (each excel file). I have corrected my typo.

[rowrow]

The following links may be useful......

http://www.excelbanter.com/showthread.php?t=72022

http://www.accountingweb.com/topic/t...le-excel-files

These suggestions do not work. I do not want to close the files. I want to save and leave the files open. For example when I am leaving my desk for a break/lunch I will save all excel files.

[:) Sixthsense :)]

I believe you have to go for VBA solution...

Refer this link to know how...

http://support.microsoft.com/default...&Product=xlw2K