Save Option - Always Create Backup

[Howard Neil]

Is it possible to set the Save Option - Always Create Backup within
Excel so that the option is always set (unless I choose to unset it for
a particular worksheet), please?

 

[Dave Peterson]

Almost...

Start a new workbook (It's gonna be used as template for all new workbooks)
Make all the changes you want each workbook that's based on this template to
have--page layout, header/footer, etc.

And save this file as Book.xlt in your XLStart folder (include that "always
create backup" setting!).

Each time you click that New icon on the standard toolbar, excel will use that
template file to create your new workbook.

 

[Dave Peterson]

Ps. Make sure you choose Template in the "save as type" box in the File|SaveAs
dialog, too.

 

[Howard Neil]

Ps. Make sure you choose Template in the "save as type" box in the File|SaveAs
dialog, too.

Thanks Dave, that should do the trick.

I was rather hoping for something that would work on all my current
workbooks (I have only just found out that the setting is not universal
:-( , fortunately before I had need of a backup ) but at least I
can safeguard future workbooks.