is this possible?

[Guest]

i have a workbook with 4 sheets on it. is it possible to save just one of the
sheets throughout the day while keeping the workbook open. when the workbook
closes the whole workbook to save? just to speed up the saving time.

 

[Frank Kabel]

Hi
AFAIK this is not possible

 

[Ian Ripsher]

i have a workbook with 4 sheets on it. is it possible to save just one of
the
sheets throughout the day while keeping the workbook open. when the
workbook
closes the whole workbook to save? just to speed up the saving time.

If I understood you correctly:
Move that sheet to its own temporary workbook, save that workbook, at the
end of the day when you want to save the whole workbook, move the worksheet
back, delete the temporary workbook and save the main one.

 

[Tom Ogilvy]

Look at Chip Pearson's page on using application.OnTime

http://www.cpearson.com/excel/ontime.htm

in the macro, you would do something similar to what Ian suggests

Workbooks("MyData.xls").Worksheets("sheet3").copy 'creates copy in new
workbook
Application.Displayalerts=False
Activeworkbook.SaveAs "C:\TempDir\MyData1.xls"
Application.DisplayAlerts = True
Activeworkbook.Close Savechanges:=False

This retains the sheet in the original workbook, but makes a copy of it and
saves it and then closes this additional workbook.