LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.office.setup,microsoft.public.word.newusers
external usenet poster
 
Posts: 6
Default Set "ALWAYS CREATE BACKUP" Option

Thanks to all for your generous contributions to this problem.
"Graham Mayor" wrote in message ...
A failure to maintain settings stored in the Word data key in the registry, such as this, is a common problem, especially in Word 2003, though it applies to other versions also. It is caused by a minor corruption in the data key. You can either rename the data key and it *should* go away, or you can force the issue with autoopen/autonew macros in the normal template when it *will* go away.

The command line to add to the macros is

Options.CreateBackup = True

http://www.gmayor.com/installing_macro.htm

I suspect it will be similar for Excel.

--
<< << << << << << <<<
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<< << << << << << <<<

"Abradaxis" wrote in message ...
In Excel, I keep setting the "always create backup" in the "save as" toolsoptions menu, but it keeps on getting erased. How can I automatically produce and keep backups in Word, and Excel on a times basis. Using Windows XP and MS Office Professional components if Office 2000, although I have Office 2007, but have not installed it as yet? Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to auto create "backup of filename.xls" in Excel 2007. waykwabu Excel Discussion (Misc queries) 2 November 24th 09 12:35 PM
2007 Need macro to auto set option buttons all to "Yes" or "No" Paula Excel Worksheet Functions 1 October 20th 09 08:07 PM
Why is the "zoom" option grayed out in "print preview?" sschreiber Excel Discussion (Misc queries) 0 November 29th 07 04:42 PM
create links to check boxes marked "good" fair"and "bad" pjb Excel Worksheet Functions 3 April 20th 06 02:17 AM
pictures to work with "data" "sort" option arad Excel Discussion (Misc queries) 1 April 18th 06 09:15 PM


All times are GMT +1. The time now is 10:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"