AutoSave function

[Guest]

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]

Create a workbook with this code in a general module:

Option Explicit
Sub auto_open()

On Error Resume Next
Workbooks("autosave.xla").Excel4IntlMacroSheets("Loc 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

 

[Dave Peterson]

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.

 

[Tom Ogilvy]

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q231117

 

[Dave Peterson]

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

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q231117

 

[Guest]

Thanks Tom!

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q231117

 

[Guest]

Thanks Dave!

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