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("ud01b.Prompt").Value = False
If Err.Number < 0 Then
MsgBox "Prompt 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, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

brentm wrote:

Hey all,

Does anyone know how to permanently set the Auto Save function to save
without the prompt? That prompt popping up every 5-10 minutes is killing
me!!! I have unchecked the prompt box every time, but it doesn't save that
preference. Help!

BrentM

--

Dave Peterson