Saving a Workbook

[siasarma]

Does anyone know how to have a workbook save automatically? Either when a change is made or just randomly, like every 10 minutes or so?

 

[Smitty]

You can use a change event to trigger saving or use the AutoRecovery feature:

On the Tools menu, click Options, and then click the Save tab.

1. Select the Save AutoRecover info every check box.
2. In the minutes box, specify how often you want your Microsoft Office program to save files.

You can also use MS MVP Jan Karel Pieterse's AutoSafe add-in.

HTH,