AutoSave function
 

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

AutoSave function
 

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

AutoSave function
 

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

AutoSave function
 

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

AutoSave function
 

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

AutoSave function
 

Thanks Tom!

"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

AutoSave function
 

Thanks Dave!

"Dave Peterson" wrote:

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