Thanks for posting the link. (I was too lazy to look for it.)

Tom Ogilvy wrote:

http://support.microsoft.com/default...;EN-US;Q231117

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
ps. I thought that one of the service packs to xl2k fixed this.

If you're using xl2k, you may want to look for updates.


Dave Peterson wrote:

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

--

Dave Peterson

--

Dave Peterson