MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Turn AutoSave on or off in Macro

Posted by Mike on February 04, 2002 2:23 PM

Does anyone know how to turn AutoSave with a macro?
I did find that "Application.Run Range("Autosave.XLA!mcs02.OnTime")" will display a single step text box with user inputs. What I need, is to have it automated and set to save every 10 minutes.

Posted by Jack in the UK on February 04, 2002 4:17 PM


Hi Mike

Sorry to ask why the code its custom so you set on off and time, cant see the gain of VBA to do this, but your code above is about wright, but if i recall the time is default 10 mins so you should be there.