| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| installed autosave function and now have issue with redo function | Excel Discussion (Misc queries) | |||
| autosave function | Setting up and Configuration of Excel | |||
| Where is the autosave function in Excel 2003? | Excel Programming | |||
| Opened Autosave but when closing workbook Autosave closes itself | Excel Worksheet Functions | |||
| Is AUTOSAVE FUNCTION embeded in the software or do I have to inst. | Excel Worksheet Functions | |||
Linear Mode
