Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to keep changed autosave time
I use Excel 2000.
The default setting for autosave is 10 minutes. I use 1 minute. But when I come back into Excel, it has changed back to 10 minutes. Anybody know how to correct this please? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to keep changed autosave time
I don't know why it doesn't stick for you, but you could do something like...
Create a workbook with this code in a general module: Option Explicit Sub auto_open() On Error Resume Next Workbooks("autosave.xla").Excel4IntlMacroSheets("L oc Table") _ .Range("ud01n.Frequency1").Value = 1 If Err.Number < 0 Then MsgBox "Timer not changed!" Err.Clear End If On Error GoTo 0 ThisWorkbook.Close SaveChanges:=False End Sub Save it into your XLStart folder (so it loads, runs, and closes each time you start excel). If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) Another option would be to dump autosave and use Jan Karel Pieterse's addin (works in any version) called AutoSafe (note spelling). It doesn't overwrite the existing workbook when it saves. It saves to a user selectable folder. And when it's done, it either deletes these backups (or puts them in the recycle bin). And the user can always restore the backups from the recycle bin. http://www.jkp-ads.com/Download.htm (look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.) Lord Cartman wrote: I use Excel 2000. The default setting for autosave is 10 minutes. I use 1 minute. But when I come back into Excel, it has changed back to 10 minutes. Anybody know how to correct this please? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
graph changed from the last time I worked with it | Charts and Charting in Excel | |||
can i see the date the last time a cell was changed? | New Users to Excel | |||
how can get autosave after a time (not autorecovery) feature ? | Excel Discussion (Misc queries) | |||
Count on cell for each time it is changed | Excel Discussion (Misc queries) | |||
Opened Autosave but when closing workbook Autosave closes itself | Excel Worksheet Functions |